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

1 vote344 views1 answer
Postgresql blocked on mac
SQL
1 vote369 views1 answer
Replace all numbers in mysql
SQL
0 vote315 views1 answer
Oracle list dblink
SQL
0 vote355 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
1 vote348 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote369 views1 answer
Select place default lat long
SQL
4 votes335 views1 answer
What are the data types in sql
SQL
1 vote330 views1 answer
Oracle db create new schema
SQL
2 votes727 views1 answer
Oracle virtual column
SQL
27 votes357 views6 answers
Set password mysql
SQL