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

5 votes204 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
7 votes212 views3 answers
How ot change name of column mysql
SQL
104 votes306 views2 answers
Like in mysql
SQL
4 votes197 views2 answers
Convert utc to est sql
SQL
0 vote192 views1 answer
T sql check active deadlock
SQL
1 vote222 views3 answers
How to create a table structure from another table in mysql
SQL
1 vote213 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
5 votes196 views1 answer
Oracle asynchronous update
SQL
31 votes204 views4 answers
How to get duplicate records with multiple field in sql
SQL
4 votes222 views4 answers
Mysql get date from datetime
SQL