No privileges on wamp server phpmyadmin

mysql phpmyadmin wamp privileges
Madizm picture Madizm · Aug 24, 2013 · Viewed 65.9k times · Source

I installed WAMP on Windows 8, and I'm having problems with MySQL privileges in phpMyAdmin.

Here, you can see the screenshot:

phpMyAdmin screenshot

As you can see, there is no privileges tab, and I can't a create new database.

Answer

Muhammad Usman Ghani picture Muhammad Usman Ghani · Apr 16, 2014

Solution:

  • Click on the User accounts tab
  • Click on a user account showing no privileges
  • Click on the Edit privileges link and tick all the check boxes

phpMyAdmin

Related questions

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 …

Read More
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

This might seem redundant but I was unable to find a correct solution. I was unable to login to mysql using the mysql console.It is asking for a password and I have no clue what I actually entered.(Is …

Read More
Fix Access denied for user 'root'@'localhost' for phpMyAdmin

I'm using WAMP Server 2.2 on a PC. In phpMyAdmin (version 5.5.24) I edited the 'root' user (with 'localhost' host) and gave it a password of 'root'. This turned out to be a big mistake that I'm trying to revert. Now when …

Read More