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

0 vote152 views1 answer
Mysql create index lost connection
SQL
2 votes142 views1 answer
Sql find missing values between two tables
SQL
0 vote200 views1 answer
Sql commands in android
SQL
0 vote155 views1 answer
Count number of entires by months sql
SQL
103 votes1.6K views1 answer
Like sql
SQL
6 votes146 views5 answers
Mysql get last insert id
SQL
0 vote173 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote149 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote139 views1 answer
Get records in sql according to month name and count
SQL
2 votes151 views1 answer
Sqlite indexes
SQL