The Warning handling occurs when skip name resolve mode is enabled for mysql
- 2020-05-13 03:39:48
- OfStack
120726 11:57:22 [Warning] 'user' entry 'root@localhost.localdomain' ignored in --skip-name-resolve mode. www.ofstack.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 network DNS parsing service causing access to MYSQL error, 1 should be enabled normally.
When enabled, the hostname cannot be used in the authorization table of mysql, only IP can be used. This warning occurs because the localhost.localdomain account information already exists in the mysql table. www. ofstack. com
Let's just delete it.
Restart MYSQL and the warning is gone.
The author Naola2001
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 network DNS parsing service causing access to MYSQL error, 1 should be enabled normally.
When enabled, the hostname cannot be used in the authorization table of mysql, only IP can be used. This warning occurs because the localhost.localdomain account information already exists in the mysql table. www. ofstack. 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 the warning is gone.
The author Naola2001