Mysql bind-address default value

check mysql version

mysql --version

Default value of bind-address shows below:

Default Value (>= 5.6.6) *
Default Value (<= 5.6.5) 0.0.0.0
So actually don't need set bind-address for above mysql version.

check mysql config file location

$ which mysqld
 /usr/local/mysql/bin/mysqld
 $ /usr/local/mysql/bin/mysqld --verbose --help | grep -A 1 "Default options"
 Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf

check is there any bind-address config in above config files.

restart mysqld service

service mysqld restart

confirm mysql user created with user@'%' to allow user connect mysql outside.

Source: stackoverflow.com

Similar codes

7 votes155 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote166 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote202 views1 answer
Sql filter rows with condition
SQL
0 vote423 views1 answer
Create pl/sql stored procedure
SQL
0 vote165 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
1 vote170 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote113 views1 answer
Now() -1 mysql
SQL
1 vote224 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote170 views1 answer
Mysql pv progres
SQL
10 votes142 views2 answers
Sql merge statement
SQL