Bind Address missing in my.cnf in MYSQL centos

Question

I have hit a problem, when I edit the my.cnf for MySQL, the bind-address line is not in the file.

Here is the content of /etc/mysql/my.cnf:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Kindly help me to achieve this.

So what is the problem? Can you connect to mysql server? Try to add this line manually. — Max, May 15 '14 at 06:14
Yes I can connect to the mysql server. I am actually implementing the master slave relation between the two servers — Megha Sharma, May 15 '14 at 06:16
Hi Megha, I hope you got your answer. Now, i got stuck same error. In 'my.cnf' file, where can i add 'bind-address' ?? — Nana Partykar, Sep 07 '15 at 11:52

score 6 · Answer 1 · answered Oct 22 '15 at 18:44

6

Just add these lines to mysqld section depending on your preferences:

If you want it to only be accessible through localhost:

bind-address=127.0.0.1
If you want it to be accessible through an interface which assigned an IP address of XXX.YYYY.WWW.ZZZZ:

bind-address=XXX.YYYY.WWW.ZZZZ
If you want it to be accessible through all interfaces available, This is not recommended except when you properly configured your firewall for it:

bind-address=0.0.0.0

answered Oct 22 '15 at 18:44

mdh.heydari

540
5
13

3

I have applied 3rd option but still not connecting. How can I check firewall? – Ahmed Numaan Jan 08 '19 at 07:57
The file has `socket=/var/lib/mysql/mysql.sock` which means you've connecting locally via UNIX socket. Remove that line first. – vesperto Mar 03 '21 at 14:50

Bind Address missing in my.cnf in MYSQL centos

1 Answers1