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:
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
Thanks
To edit an existing user, simply click the pencil icon to the right of that user in the User accounts page. You can then edit their global- and database-specific privileges, change their password, or even copy those privileges to a new user.
If you are logged into WHM w/ root privileges, you can see the users for each table, and their privileges by clicking on the db, and then a table. You will now see the privileges tab within the table view navigation.
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)
For people who run into this problem while using cPanel / WHM the post linked to below on the cPanel site states:
Per internal case number 37402, the functionality to add/delete/rename users and databases through phpMyAdmin has been removed because of the database mapping feature.
That means the Users / Privileges tab has been removed from cPanel's version of phpMyAdmin and it doesn't sound like it's coming back. The post is from December of 2013.
http://forums.cpanel.net/f354/phpmyadmin-users-tab-gone-367661.html
The cPanel staff member cPanelMichael who answered the post recommended two alternatives.
You gotta love progress.
I solved the problem like this:
1) I set a root password through SQL query like this:
root@localhost
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('YOURPASSWORDHERE');
2) Search for config.inc.php
in your wamp/xampp folder and change auth_type
:
$cfg['Servers'][$i]['auth_type'] = 'SOMETHING';
- change 'SOMETHING'
to 'cookie'
$cfg['Servers'][$i]['auth_type'] = 'cookie';
(or http if you wish)
-3) clear/delete all browser cookies for your server (usually look for localhost or 127.0.0.1 cookies)
4) Go to phpyadmin's webpage again - now you will be prompted with login box (html or http - depends on whether you set the cookie or http)
5) LOGIN - AND YOU'RE DONE ! :) Suddenly 'Privileges'/'Users' tab is shown, the exit button appears suddenly too ! :) (next to the "little house"-left-top)
PS: config.inc.php
contains more interesting settings :)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With