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

本帖最后由 qwqg_cu 于 2010-04-21 11:07 编辑

删除授权表中有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