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 vote264 views1 answer
Convert to hexadecimal sql
SQL
1 vote265 views1 answer
Create new table from old table with data
SQL
0 vote273 views1 answer
Datagrip execute procedure
SQL
1 vote216 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
0 vote314 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote284 views1 answer
Hour differeence in mysql
SQL
0 vote253 views2 answers
Sql update top 100
SQL
0 vote279 views1 answer
Mysql user set plugin
SQL
0 vote279 views1 answer
Stored procedures example
SQL
1 vote277 views1 answer
Psql connect
SQL