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 vote219 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
5 votes198 views1 answer
Oracle ORA-00054 origin
SQL
0 vote193 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote204 views1 answer
Create table database in psql
SQL
0 vote239 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote211 views1 answer
Mysql get last 2 month data
SQL
8 votes233 views1 answer
Oracle current date plus 1 month
SQL
0 vote210 views1 answer
Insert ip address in mysql
SQL
0 vote199 views1 answer
Sql trying to delete database in use
SQL
11 votes249 views1 answer
How to get ddl for materialized view
SQL