在你认为这是一个重复的问题之前,我相信我有一个独特的例子,即使它有点愚蠢.
几天前,我将我的Ubuntu 10.04服务器上的MySQL版本升级到了5.3.3(比Ubuntu 10.04的版本早).今天,我试图登录phpMyAdmin获取一些信息,发现了有点可怕的Connection for controluser as defined in your configuration failed
错误.
在遵循了关于如何解决这个问题的几个SO问题的描述之后,我陷入了困境.
- 我try 了reconfigure phpMyAdmin次,但没有成功.
- 我试图删除它,但它无法从数据库中删除权限,因此失败.
- 然后我try 从数据库中删除manually remove the privileges个用户(我可能会添加一些愚蠢的内容),然后删除数据库,然后删除用户(
flush privileges
个). - 我完全放弃了phpMyAdmin的整个安装(删除应用程序和/etc/phpMyAdmin目录)并重新安装(使用apt get),但它说phpMyAdmin用户的权限已经存在:
granting access to database phpmyadmin for phpmyadmin@localhost: already exists
这就是我剩下的.我有一项授权,我不能修改,也不能撤销:
mysql> show grants for 'phpmyadmin'@'localhost';
+-------------------------------------------------------------------------------------------------------------------+
| Grants for phpmyadmin@localhost |
+-------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'phpmyadmin'@'localhost' IDENTIFIED BY PASSWORD '*46CFC7938B60837F46B610A2D10C248874555C14' |
| GRANT ALL PRIVILEGES ON `phpmyadmin`.* TO 'phpmyadmin'@'localhost' |
+-------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.26 sec)
mysql> revoke usage on *.* from 'phpmyadmin'@'localhost';
ERROR 1141 (42000): There is no such grant defined for user 'phpmyadmin' on host 'localhost'
mysql> revoke usage on *.* from 'phpmyadmin'@'localhost' identified by 'trustno1';
ERROR 1141 (42000): There is no such grant defined for user 'phpmyadmin' on host 'localhost'
(别担心,我不再使用此密码,但它是以前使用的密码,而不是我为新的phpmyadmin安装 Select 的密码).
如何完全取消这些授权/特权?如果需要的话,我很乐意从头开始(phpmyadmin,而不是DB).