Mysql错误日志:[Warning] IP address ‘xxxx‘ could not be resolved: Name or service not known

mysql日志显示：
[Warning] IP address 'xxxx' could not be resolved: Name or service not known

解决办法：禁用dns反查即可，进入/etc 找到mysql的配置文件my.cnf（linux环境下）或者my.ini(windows环境下)进行编辑加入如下一行即可：

[mysqld]
skip-name-resolve