How the MySQL database listens to only a specific address

This article introduces the knowledge of "how the MySQL database only listens to a specific address". Many people will encounter this dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Q: how can I specify that MySQL only listens to a specific address?

A: a more common way is to add bind-address=127.0.0.1 in the mysqld section of my.cnf. But there are also people who do it the following way.

For the sake of data security, consider keeping MySQL only waiting at 127.0.0.1, so that it cannot be accessed directly from the Internet. Modify the / etc/init.d/ file and find a line similar to the following in the start section:

$bindir/mysqld_safe-datadir=$datadir

-- pid-file=$pid_file &

Modified to:

$bindir/mysqld_safe-datadir=$datadir

-pid-file=$pid_file-bind-address=127.0.0.1 &

Restart MySQL:

/ etc/init.d/mysql restart

Finally, netstat-l confirms:

Tcp 0 0 localhost:mysql *: * LISTEN

OK

This is the end of "how the MySQL database listens to only a specific address". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!