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

4 votes181 views1 answer
Mysql ip address data type
SQL
3 votes231 views1 answer
Oracle apex warn on unsaved changes
SQL
6 votes175 views2 answers
Oracle undotbs usage
SQL
0 vote167 views1 answer
Calculate age in sql
SQL
21 votes163 views3 answers
Sql average
SQL
0 vote170 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote190 views1 answer
Postgresql create table with timestamp
SQL
0 vote230 views1 answer
Oracle create package specification
SQL
0 vote165 views1 answer
Mysql record group by created date count
SQL
0 vote180 views1 answer
Sql delete dastabase
SQL