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 vote211 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote318 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote216 views1 answer
Less than date query sqlachemy
SQL
0 vote224 views1 answer
Testing sql queries
SQL
0 vote187 views1 answer
Sql clear table
SQL
0 vote191 views1 answer
Mysql cli output to a file
SQL
7 votes316 views2 answers
Drop index oracle
SQL
7 votes198 views1 answer
Oracle pagination query offset
SQL
0 vote201 views1 answer
Generate sequence number in sql server
SQL
0 vote208 views2 answers
Timing sql queries
SQL