错误日志有类似警告：
120119 16:26:04 [Warning] IP address '192.168.0.110' could not be resolved: Name or service not known
120119 16:26:04 [Warning] IP address '192.168.0.104' could not be resolved: Name or service not known
120119 16:26:04 [Warning] IP address '192.168.0.147' could not be resolved: Name or service not known
通过show processlist发现大量类似如下的连接：
|592|unauthenticated user|192.168.3.20:35320|NULL|Connect| |login|NULL|
|593|unauthenticated user|192.168.3.20:35321|NULL|Connect| |login|NULL|
|594|unauthenticated user|192.168.3.20:35322|NULL|Connect| |login|NULL|
skip-name-resolve 参数的目的是不再进行反解析（ip不反解成域名），这样可以加快数据库的反应时间。
修改配置文件添加并需要重启：
[mysqld]
skip-name-resolve
添加后发现错误日志有
120203 10:21:06 [Warning] 'user' entry 'root@r590ubuntu' ignored in --skip-name-resolve mode.
120203 10:21:06 [Warning] 'user' entry '@r590ubuntu' ignored in --skip-name-resolve mode.
只需去服务器里边把用户root@r590ubuntu和@r590ubuntu删除即可。
posted on 2013-12-04 18:26
回忆之城 阅读(163)
评论(0) 编辑 收藏 引用 所属分类:
数据库