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 vote135 views1 answer
Mysql order by rand limit 1 really slow
SQL
2 votes133 views2 answers
Set database timezone mysql
SQL
2 votes164 views3 answers
3 days back in sql server
SQL
-1 vote130 views1 answer
Get id from just inserted row mysql server python
SQL
9 votes130 views2 answers
Sql limit order by
SQL
0 vote136 views2 answers
Sql searching via key word
SQL
3 votes144 views1 answer
Select table column in sql
SQL
8 votes128 views2 answers
Between operator
SQL
3 votes132 views2 answers
Truncate all tables
SQL
2 votes139 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL