mysql bind address default value

Solutions on MaxInterview for mysql bind address default value by the best coders in the world

showing results for - "mysql bind address default value"
Leon
05 Sep 2020
1check mysql version
2
3mysql --version
4
5Default value of bind-address shows below:
6
7Default Value (>= 5.6.6) *
8Default Value (<= 5.6.5) 0.0.0.0
9So actually don't need set bind-address for above mysql version.
10
11check mysql config file location
12
13$ which mysqld
14 /usr/local/mysql/bin/mysqld
15 $ /usr/local/mysql/bin/mysqld --verbose --help | grep -A 1 "Default options"
16 Default options are read from the following files in the given order:
17/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf
18
19check is there any bind-address config in above config files.
20
21restart mysqld service
22
23service mysqld restart
24
25confirm mysql user created with user@'%' to allow user connect mysql outside.