接着刚才的帖子， 普通用户无法在本地登录了。。。

TOADLover

本地操作：
mysql> flush privileges
    -> ;
ERROR 1227 (HY000): Access denied; you need the RELOAD privilege for this operation
mysql>
------------------------------------
远程操作：


[ 本帖最后由 TOADLover 于 2009-9-24 13:14 编辑 ]

TOADLover

嗯，重启后就可以了：
---------------------------
[root@MySQLServer ~]# service mysqld restart
Stopping MySQL:  [  OK  ]
Starting MySQL:  [  OK  ]
[root@MySQLServer ~]# mysql -utest2 -hlocalhost -pabc
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select user();
+-----------------+
| user()          |
+-----------------+
| test2@localhost |
+-----------------+
1 row in set (0.01 sec)

mysql> select user,host,password from mysql.user;
ERROR 1044 (42000): Access denied for user 'test2'@'localhost' to database 'mysql'
mysql>

TOADLover

mysql> quit
Bye
[root@MySQLServer ~]# mysql -uroot -hlocalhost
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.1.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select user,host,password from mysql.user;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
mysql> select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

mysql>
----------------------------------------
此时此刻，我究竟有没有用root用户登录进去，如果登录进去了，怎么会''@'localhost' ，@前面摆明是没有用户啊？？？？

ruochen

呵呵

将mysql.user表中user是空的两个记录删除吧
然后刷新下权限

ruochen

再将下面行的host改为localhost，刷新权限
root Mysqlserver


记得修改权限和添加用户操作后都要刷新权限

TOADLover

截图：
-------------


[ 本帖最后由 TOADLover 于 2009-9-24 13:36 编辑 ]

TOADLover

我用
delete from mysql.user where user is null
还是应该用
delete from mysql.user where user = ''

TOADLover

记得修改权限和添加用户操作后都要刷新权限!
------------
下次记得了。。

ruochen

原帖由 TOADLover 于 2009-9-24 13:36 发表
我用
delete from mysql.user where user is null
还是应该用
delete from mysql.user where user = ''

将delete换成select查询一下就知道了呀

ruochen

再说你那个软件应该是是可以打开表的吧
不能直接删除记录么
没有按钮来做权限刷新么