用户root@127.0.0.1 拥有all 和 WITH GRANT OPTION 权限，但是无法创建用户。

o12q0315

用户root@127.0.0.1  拥有all 和 WITH GRANT OPTION 权限，但是无法创建用户。
求各位大侠帮忙，谢谢~
mysql>

mysql> show user();
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'user()' at line 1
mysql> select user();   
+----------------+
| user()         |
+----------------+
| root@127.0.0.1 |
+----------------+
1 row in set (0.00 sec)

mysql> show grants for root@127.0.0.1 ;
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@127.0.0.1                                                                                                                                                                                                                                                                                                                                     |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'root'@'127.0.0.1' WITH GRANT OPTION |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES  on *.* to mhaadmin@172.30.84.11 identified by 'xxxxx';
ERROR 1045 (28000): Access denied for user 'root'@'127.0.0.1' (using password: NO)
mysql>
mysql> GRANT ALL PRIVILEGES  on *.* to mhaadmin@172.30.84.11 identified by 'xxxxx' WITH GRANT OPTION;
ERROR 1045 (28000): Access denied for user 'root'@'127.0.0.1' (using password: NO)
mysql>

foxmile

源库权限变化过，覆盖了你本地root权限，需要向办法恢复。发你了我本地的root账号，你试试。

foxmile

收费咨询哈。要给钱的回复 2# foxmile


   

o12q0315

foxmile 发表于 2014-01-16 17:03
源库权限变化过，覆盖了你本地root权限，需要向办法恢复。发你了我本地的root账号，你试试。

应该是你说的mysqldump过去后的问题，我再试一试