关于mysql的skip-name-resolve 参数设置

zhangweibo

mysql 4.1.22

my.cnf加了如下设置
skip-name-resolve

但在mysql的启动信息中发现如下错误

070626  7:40:24 [Warning] 'user' entry 'root@web2' ignored in --skip-name-resolve mode.
070626  7:40:24 [Warning] 'user' entry '(null)@web2' ignored in --skip-name-resolve mode.


网上找了一圈好像也没有解决方案，不知道到底怎么设置才正确。

yejr

去掉这个参数就行

zhangweibo

但怎么解决unauthenticated user 问题

mysql>show processlist;

| 20681949 | unauthenticated user | 10.10.4.193:52497 | NULL  | Connect |        | Reading from net                 | NULL                                                                                                 |
| 20681948 | unauthenticated user | 10.10.4.193:52495 | NULL  | Connect |        | Reading from net                 | NULL  


查了google，都说启动的时候，加skip-name-resolve这个参数，去掉的话，上面的问题如何解决。

yejr

那就重新授权，不再采用主机名的方式授权

showsa

给/etc/hosts 添加一行

10.10.4.193 web2

yueliangdao0608

如果用IP地址的话就不用这么麻烦了。

zhangweibo

我本身是用% 授权任何地址，然后hosts文件也是写了，只不过程序里用了10.10.4.193 web2 里的web2是不是得改用ip呀

yejr

用5楼的办法也可以

hansonhan

加 skip-name-resolve 参数是没有错的，估计你的授权表肯定存储了不合法的数据。

qwqg_cu

删除授权表中有hostanme的记录，然后重启mysqld，可以解决此问题。

mysql> select user,host from mysql.user where host <> 'localhost' ;
+------+-----------+
| user | host      |
+------+-----------+
| root | 127.0.0.1 |
|      | DB1       |
| root | DB1       |
+------+-----------+
3 rows in set (0.00 sec)

mysql> delete from user where user=" " and host="DB1";
ERROR 1046 (3D000): No database selected
mysql> use mysql
Database changed
mysql> delete from user where user=" " and host="DB1";
Query OK, 1 row affected (0.00 sec)

mysql> delete from user where user="root" and host="DB1";
Query OK, 1 row affected (0.00 sec)

mysql> select user,host from mysql.user where host <> 'localhost' ;
+------+-----------+
| user | host      |
+------+-----------+
| root | 127.0.0.1 |
+------+-----------+
1 row in set (0.00 sec)

日志显示如下：
100421 10:19:32  mysqld started
100421 10:19:32  InnoDB: Started; log sequence number 0 43655
100421 10:19:32 [Warning] 'user' entry 'root@DB1' ignored in --skip-name-resolve mode.
100421 10:19:32 [Warning] 'user' entry '@DB1' ignored in --skip-name-resolve mode.
100421 10:19:32 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.0.77-log'  socket: '/data/mysql/mysql.sock'  port: 3306  Source distribution
100421 10:59:55 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

100421 10:59:55  InnoDB: Starting shutdown...
100421 10:59:56  InnoDB: Shutdown completed; log sequence number 0 43655
100421 10:59:56 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

100421 10:59:56  mysqld ended

100421 10:59:57  mysqld started
100421 10:59:57  InnoDB: Started; log sequence number 0 43655
100421 10:59:57 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.0.77-log'  socket: '/data/mysql/mysql.sock'  port: 3306  Source distribution