How to deal with Warning when mysql enables skip-name-resolve mode

This article mainly introduces "how to deal with Warning when mysql enables skip-name-resolve mode". In daily operation, I believe that many people have doubts about how to deal with Warning when mysql enables skip-name-resolve mode. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubt of "how to deal with Warning when mysql enables skip-name-resolve mode". Next, please follow the editor to study!

How to deal with Warning when skip-name-resolve mode is enabled

When optimizing the MYSQL configuration, join skip-name-resolve, check the startup log when restarting MYSQL, and find a warning message.

120726 11:57:22 [Warning] 'user' entry' root@localhost.localdomain' ignored in-skip-name-resolve mode. Www.2cto.com

120726 11:57:22 [Warning] 'user' entry' @ localhost.localdomain' ignored in-- skip-name-resolve mode.

Skip-name-resolve is to disable dns parsing to avoid the error of accessing MYSQL caused by the network DNS parsing service, which should generally be enabled.

When enabled, hostnames cannot be used in the authorization table of mysql, only IP can be used. This warning occurs because localhost.localdomain account information already exists in the mysql table. Www.2cto.com

Let's just delete it.

Mysql > use mysql

Mysql > delete from user where HOST='localhost.localdomain'

Query OK, 2 rows affected (0.00 sec)

Restart MYSQL and find that the warning is gone.

At this point, the study on "how to deal with Warning when mysql enables skip-name-resolve mode" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!