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 vote324 views1 answer
Is not numeric sql
SQL
5 votes296 views1 answer
Alter table add comment oracle
SQL
0 vote307 views4 answers
Mysql count table rows
SQL
0 vote304 views1 answer
Greater than or equal to symbol in postgres
SQL
28 votes346 views6 answers
Sql update
SQL
0 vote290 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote286 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote306 views1 answer
Case insensitive sql
SQL
0 vote327 views1 answer
Reindex mssql table
SQL
-3 votes390 views8 answers
Sql to c# linq converter online
SQL