phpmyadmin 不显示“权限"；标签

2022-01-05 00:00:00 wamp mysql phpmyadmin privileges

我在 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 身份登录
  • 重新安装 wamp
  • 重置我的 mysql 用户
  • 对用户运行 mysql 检查
  • 清除我的缓存

通过这些测试，我收到了以下错误:找不到文件:'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，是一个特别影响谷歌浏览器的错误，但我不能肯定其他浏览器.请注意，您可以通过 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)

相关文章