How to specify that MySQL only listens to a specific address

In mysqld section of my. cnf, add a bind-address127.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: The more common way is to add bind-address127.0.0.1 in mysqld section of my. cnf. However, some people follow these steps. For data security,

In mysqld section of my. cnf, add 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,

In mysqld section of my. cnf, add 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/mysql restart

Finally, confirm netstat-l:

Tcp 0 0 localhost: mysql *: * LISTEN