No privileges on wamp server phpmyadmin

Question

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.

In the phpMyAdmin folder on your disk, there is a `config.inc.php` file. Which user name is listed therein? — mynetx, Aug 24 '13 at 16:48
the username is root and the pass is empty $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; thank you — Madizm, Aug 24 '13 at 18:12
Possible duplicate of [Phpmyadmin - Mysql no privileges](https://stackoverflow.com/questions/11755214/phpmyadmin-mysql-no-privileges) — nelaaro, Aug 30 '17 at 09:01
See my answer (works on Aug 2018) https://stackoverflow.com/questions/14699195/phpmyadmin-doesnt-show-privileges-tab/52114751#52114751 — Rav, Aug 31 '18 at 11:44

score 17 · Answer 1 · edited Jun 18 '20 at 15:23

17

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

edited Jun 18 '20 at 15:23

Kate Orlova

3,225
5
11
35

answered Apr 16 '14 at 05:42

Muhammad Usman Ghani

1,279
13
19

I don't have a logout button. And I am logged in as root – Curtis Jul 01 '14 at 21:23
use root as username and your password you set during phpmyadmin installation – 0x3bfc Jul 31 '15 at 20:24
Exactly what was needed! – Rimfire Dec 24 '16 at 14:49

score 3 · Answer 2 · answered Mar 01 '14 at 20:14

3

i just write UserName root and leave the password blank it work for me

answered Mar 01 '14 at 20:14

Maryam

109
4

score 3 · Answer 3 · answered Jul 23 '17 at 05:30

3

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

answered Jul 23 '17 at 05:30

Deepak Sukumar

31
1

did not helped. – LEMUEL ADANE Nov 15 '18 at 23:44

score 2 · Answer 4 · answered Oct 30 '13 at 17:37

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

score 1 · Answer 5 · answered Jun 10 '14 at 09:45

1

Hey i just tried this and it worked type the "root" as username and the password you set during installation. Worked

answered Jun 10 '14 at 09:45

SpeedMan86

11
3

score 1 · Answer 6 · answered Jul 10 '18 at 01:26

1

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.

answered Jul 10 '18 at 01:26

user10056588

11
1

score 0 · Answer 7 · answered Aug 24 '13 at 18:17

0

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 root@127.0.0.1.

answered Aug 24 '13 at 18:17

mynetx

878
7
25

That works for the tables on the left side, but i steel cant see the privileges tab and i cant create database. http://prntscr.com/1n64oa http://prntscr.com/1n650c – Madizm Aug 24 '13 at 18:41
Would you mind telling what the following SQL query result is? `select Host, User, Select_priv from mysql.user` – mynetx Aug 24 '13 at 19:22
Ok, now on phpMyAdmin's home page, in the Database server section, do you see "User: root@localhost" ? – Marc Delisle Aug 25 '13 at 12:36
SELECT command denied to user ''@'localhost' for table 'user' – Curtis Jul 01 '14 at 21:21

score -1 · Answer 8 · answered Dec 12 '13 at 06:54

-1

you just ned to enter the username as 'root' and leave password blank. You will be able to create database.

answered Dec 12 '13 at 06:54

Husain

11

No privileges on wamp server phpmyadmin

8 Answers8