parameter use:
skip-name-resolve #禁止MySQL对外部连接进行DNS解析skip-grant-tables
To Add the--skip-name-resolve method:
Modify the configuration file additions and require a restart.
parameter optimization:
The purpose of the Skip-name-resolve parameter is to no longer reverse-parse (IP does not reverse into a domain name), which can speed up the response time of the database.
internal DNS server, the IP of each server to do a reverse resolution, but not the internal IP to do reverse resolution, so use Skip-name-resolve after using the intranet address to the MYSQLSLAP request response half faster.
the error log is found after adding the "--skip-name-resolve mode" parameter
2 |
120203 10:21:06 [Warning] ' user ' entry ' @jimmyli ' ignoredin--skip-name-resolve mode. |
just go to the server inside the user [email protected] and @jimmyli Delete.
Tip warning Information:
1 |
130739 11:12:22 [Warning] ' user ' entry ' [email protected] ' ignoredin--skip-name-resolve mode. |
in general, when optimizing the MySQL configuration parameters, add "--skip-name-resolve" and then check the startup log when restarting MySQL and find a warning message. Above
cause Analysis:
"--skip-name-resolve mode" is to disable DNS resolution, to avoid the network DNS resolution service to raise access to MySQL error, generally should be enabled.
when "--skip-name-resolve mode" is enabled, the hostname cannot be used in the MySQL authorization table, only IP is used, this warning occurs because the Localhost.localdomain account information already exists in the MySQL table.
Workaround:
The deletion of the warning account will be solved.
mysql command line:
5 |
Query OK, 2rowsaffected (0.00 sec) |
Finally, restart MySQL, and then look at the error message prompt, the log found that the warning is gone. This method is warning when MySQL is enabled with Skip-name-resolve mode.
Optimizing MySQL when opening skip-name-resolve parameters