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 vote351 views1 answer
Sqlite update where exists
SQL
0 vote342 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote346 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote350 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote361 views1 answer
Get foreign table names mysql
SQL
0 vote444 views1 answer
Redshift running queries
SQL
6 votes371 views2 answers
Drop foreign key
SQL
0 vote367 views1 answer
Sql find all different values in column
SQL
0 vote382 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote368 views2 answers
How to type a blank discord messgae
SQL