Phpmyadmin不会显示“特权"标签 [英] Phpmyadmin doesn't show "privileges" tab

问题描述

我在Windows上安装了WAMP，无论如何我似乎都无法在PhpMyAdmin中显示特权"选项卡.阅读其他论坛的讨论和文章，我已经做了以下事情:

I have WAMP installed on Windows, and I can't seem to get the "privileges" tab to show in PhpMyAdmin no matter what. Reading other forum discussions and articles, I have done the following:

• 检查以确保我以root用户身份登录
• 重新安装了沼泽
• 重置我的mysql用户
• 对用户运行mysql检查
• 清除了我的缓存

通过这些测试，我得到了以下错误:Can't find file: 'user' (errno: 2).谷歌搜索该解决方案被证明是徒劳的.任何帮助将不胜感激

Through those tests, I have gotten the following error: Can't find file: 'user' (errno: 2). A google search for a solution to that proved futile. Any help would be appreciated

更新:屏幕截图

谢谢

推荐答案

如果确定您以root用户身份运行，请尝试清除cookie，然后刷新.这就是AFAIK，这是一个会特别影响Google Chrome的错误，但对于其他浏览器，我不能肯定地说.请注意，您可以通过Chrome中的开发者"标签选择要删除的Cookie.您只需要删除localhost cookie.

If you are sure that you are running as root, try clearing your cookies then refresh. This, AFAIK, is a bug affecting Google Chrome in particular but I can't say for certain for other browsers. Note that you can select what cookies to delete via the developers tab in Chrome. You need to delete only the localhost cookies.

哦，不.因此，您确实删除了用户"表.我的建议是，您可以在数据库mysql中为表找到CREATE脚本，或者进行完全重新安装(看来，您损失的数据库并不多).仅作记录:

Oh no. So you've really deleted the 'user' table. My suggestion is that you either find CREATE scripts for the tables in database mysql or do a complete reinstall (as it appears, you don't have much DB's to lose anyway). Just for the record:

mysql> USE mysql;
Database changed
mysql> SHOW TABLES;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| event                     |
| func                      |
| general_log               |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| host                      |
| ndb_binlog_index          |
| plugin                    |
| proc                      |
| procs_priv                |
| proxies_priv              |
| servers                   |
| slow_log                  |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
24 rows in set (0.00 sec)

这篇关于Phpmyadmin不会显示“特权"标签的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！