phpMyAdmin报告“无特权" [英] phpMyAdmin reports 'No Privileges'

问题描述

长话短说，我最终从EasyPHP中的PHPMyAdmin中删除了root用户.经过一番研究，我使用了skip-grant-tables重新获得数据库访问权限.但是，现在，由于root用户具有"无权限"，我无法执行任何操作.

Long story short, I ended up deleting the root user from PHPMyAdmin in EasyPHP. After some researching, I used skip-grant-tables to regain database access. Now, however, I cannot do anything as the root user has 'No Privileges.'

也就是说，当我以"root"身份登录时，确实可以通过SQL创建数据库.

我尝试了以下类似的方法:

I've tried the following, and similar:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
FLUSH PRIVILEGES;

不过，我什么也做不了.此外，我收到此消息:

Still, I can't do anything. Additionally, I have this message:

用于链接表的其他功能已被停用.要找出原因，请点击此处.

点击显示:

$cfg['Servers'][$i]['pmadb'] ...    OK
$cfg['Servers'][$i]['relation'] ... not OK [ Documentation ]
General relation features: Disabled

$cfg['Servers'][$i]['table_info'] ...   not OK [ Documentation ]
Display Features: Disabled

$cfg['Servers'][$i]['table_coords'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['pdf_pages'] ...    not OK [ Documentation ]
Creation of PDFs: Disabled

$cfg['Servers'][$i]['column_info'] ...  not OK [ Documentation ]
Displaying Column Comments: Disabled
Browser transformation: Disabled

$cfg['Servers'][$i]['bookmarktable'] ...    not OK [ Documentation ]
Bookmarked SQL query: Disabled

$cfg['Servers'][$i]['history'] ...  not OK [ Documentation ]
SQL history: Disabled

$cfg['Servers'][$i]['designer_coords'] ...  not OK [ Documentation ]
Designer: Disabled

$cfg['Servers'][$i]['tracking'] ... not OK [ Documentation ]
Tracking: Disabled

重新安装EasyPHP无法解决问题，VirtualStore中不存在任何内容(如一篇论坛文章所建议).我应该找一个特定的MySQL文件吗?

Reinstalling EasyPHP doesn't fix the problem, and nothing exists in VirtualStore (as one forum post suggested). Is there a specific MySQL file I should be looking for?

有什么想法吗?这确实阻止了我的应用程序开发.

Any ideas? This has really put a stop to my application development.

谢谢.

推荐答案

这太烦人了.

这似乎是phpMyAdmin的错误.

It appears to be a bug with phpMyAdmin.

清除您的浏览器cookie，这是phpMyAdmin已缓存"您没有(或可能在某时没有)创建数据库访问权限的事实.

Clear your browser cookies, what's happening is phpMyAdmin has "cached" the fact that you do not (or possibly didn't have at some point) create database access.

除了在浏览器窗口中删除phpMyAdmin的cookie(以获取新的会话ID")或删除phpMyAdmin Web服务器上的会话文件外，没有其他方法可以重置它.

There's no way to reset it other than deleting your cookies for phpMyAdmin in your browser window (to get a new 'session id'), or deleting the session files on the phpMyAdmin web server.

这篇关于phpMyAdmin报告“无特权"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！