- 论坛徽章:
- 0
|
原帖由 shujun579 于 2009-8-10 13:52 发表 ![]()
select user,host from mysql.user;
show grants for 'root'@'localhost';
贴出来看一下
mysql> select user,host from mysql.user;
+------+-----------------------+
| user | host |
+------+-----------------------+
| root | % |
| root | 127.0.0.1 |
| | localhost |
| | localhost.localdomain |
| root | localhost.localdomain |
+------+-----------------------+
5 rows in set (0.00 sec)
mysql> show grants for 'root'@'localhost'
-> ;
ERROR 1141 (42000): There is no such grant defined for user 'root' on host 'localhost'
这是数据库里的情况, |
|