拒绝用户' root '@'localhost‘的访问，尽管为用户根授予了全部权限

Question

我已经登录到用户根目录，并尝试运行以下命令：

mysql>     GRANT SELECT,UPDATE,INSERT,DELETE ON cms.* TO 'support'@'localhost';
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'cms'

Root拥有完全的权限，但可以进行所有更改。这是给根用户的授权。

mysql> show grants for root@localhost;
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost                                                                                                              |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*929CD22466796BD0C90085810B3CCCA372C6B5D7' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Answer 1

虽然“support”@‘127.0.0.1’并不存在，但我还是在127.0.0.1上做了一笔赠款：

GRANT SELECT,UPDATE,INSERT,DELETE ON cms.* TO 'support'@'127.0.0.1';

由于某种原因，所有这些查询都开始工作：

GRANT SELECT,UPDATE,INSERT,DELETE ON cms.* TO 'support'@'localhost';
GRANT SELECT,UPDATE,INSERT,DELETE ON cms.* TO 'support'@'172.29.20.%';
GRANT ALL ON *.* TO 'root'@'localhost';