I've been setting up servers for so many times and it was been my habit that all my applications/services should be listening on one of server's ip address. I just installed MySQL and by default, it listen to 0.0.0.0. Server's ip address is 10.0.1.101 and I would like to listen it to that ip address instead of 0.0.0.0. To change this, you should have an entry bind-address on your /etc/my.cnf.
bind-address=10.0.1.101
You should restart mysqld. Reloading mysqld would not work. I tried it but it didn't work I guess I need to stop also all applications writing to the database.
[root@centosprod1 ~]# netstat -tunlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 10.0.1.101:22 0.0.0.0:* LISTEN 21154/sshd
tcp 0 0 127.0.0.1:32000 0.0.0.0:* LISTEN 18834/veaintf
tcp 0 0 0.0.0.0:5634 0.0.0.0:* LISTEN 17820/xprtld
tcp 0 0 10.0.1.101:3306 0.0.0.0:* LISTEN 21376/mysqld
tcp 0 0 :::5634 :::* LISTEN 17820/xprtld
udp 0 0 0.0.0.0:68 0.0.0.0:* 1092/dhclient
No comments:
Post a Comment