Search code examples
mysqlphpmyadminwampprivileges

Phpmyadmin doesn't show "privileges" tab


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:

  • Checked to make sure that I'm logged in as root
  • Reinstalled wamp
  • Reset my mysql users
  • Run mysql check on users
  • Cleared my cache

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

Update: Screenshot enter image description here

Thanks


Solution

  • 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.

    Edit:

    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)