Reputation: 381
I installed WAMP on Windows 8, and I'm having problems with MySQL privileges in phpMyAdmin.
Here, you can see the screenshot:
As you can see, there is no privileges tab, and I can't a create new database.
Upvotes: 22
Views: 68895
Reputation: 1279
Solution:
Upvotes: 17
Reputation: 11
Your problem is your authentication. If you are accessing phpMyAdmin through WAMP, then you need to check the files in WAMP for the proper configuration.
Upvotes: 1
Reputation: 41
Go to phpmyadmin webpage under user accounts tab and check if the root has all_privileges
and still if you are not able create db
Go to mysql console login as root and type: flush privileges;
now reload phpmyadmin page and you should be in synch
Upvotes: 4
Reputation: 11
Hey i just tried this and it worked type the "root" as username and the password you set during installation. Worked
Upvotes: 1
Reputation: 109
i just write UserName root and leave the password blank it work for me
Upvotes: 3
Reputation: 11
you just ned to enter the username as 'root' and leave password blank. You will be able to create database.
Upvotes: -1
Reputation: 21
for no priviledge error, the solution is this:
It is not a file permission issue, the mysql user you logged in as doesn't have the right to create databases. You need to login as root for full permission, which I understand you are not. If I am not mistaken, the default password for "root" is empty (blank, nothing, ""), so try that. Once you are logged in as root in phpMyAdmin, you will be able to create databases or create another user with full permission.
kudos to:: http://www.theadminzone.com/forums/showthread.php?t=98676
Upvotes: 2
Reputation: 898
You might be able to start the MySQL server with --skip-grant-tables
option. Then access the Users tab in phpMyAdmin, and delete the password for root@localhost
and [email protected]
.
Upvotes: 0