The MySQL database only listens to a specific address in the mysqld section of my. cnf and adds bind-address = 127.0.0.1. MySQL can only listen to a specific address.
Q: How can I specify that MySQL only listens to a specific address?
A: A common method is to add bind-address = 127.0.0.1 in mysqld section of my. cnf. However, some people follow these steps.
For data security, you can consider allowing MySQL to only wait on 127.0.0.1, so that you cannot directly access the database from the Internet. Modify the/etc/init. d/mysql file and find a line similar to the following in the start section:
$ Bindir/mysqld_safe -- datadir = $ datadir
-- Pid-file = $ pid_file &
Modify:
$ Bindir/mysqld_safe -- datadir = $ datadir
-- Pid-file = $ pid_file -- bind-address = 127.0.0.1 &
Restart MySQL:
/Etc/init. d/mysqlrestart
Finally, confirm netstat-l:
Tcp00localhost: mysql *: * LISTEN