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 vote124 views1 answer
Postgres cast as currency format
SQL
0 vote117 views1 answer
Exclude last comma separated string mysql
SQL
2 votes114 views3 answers
Current month mysql query
SQL
1 vote69 views1 answer
How to run sql script
SQL
0 vote112 views1 answer
Mysql group by derived column
SQL
0 vote76 views1 answer
Sql new line output
SQL
0 vote131 views1 answer
Netstat -tln mysql
SQL
2 votes114 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote118 views1 answer
Longtext sql
SQL
0 vote109 views1 answer
Take sql dump in to file
SQL