phpMyAdmin 报告“无权限"

2022-01-05 00:00:00 mysql phpmyadmin easyphp

长话短说,我最终在 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 网络服务器上的会话文件之外,没有其他方法可以重置它.

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.

相关文章