No privileges in phpmyadmin

Question

I know this question has been asked many times but none of the other solutions put in similar questions have worked.

I am trying to move my a WordPress site from one host to another. I have imported the wp database on to the new host and all I have to do is access the 'privileges' tab on phpmyadmin to make a user with all privileges. However, the privileges tab is not there. I have tried logging in as root but I get the message saying "Login without a password is forbidden by configuration (see AllowNoPassword)".

I have tried clearing my cookies and also adding a new user through the control panel making sure to tick the box saying "Give this user DBO access" but to no avail.

Does anyone know how I can solve this issue and make the privileges tab appear in phpmyadmin?

Thanks in advance,

James

Answer 1

Depending on your phpMyAdmin version, the "Privileges" tab has been renamed to "User accounts".

"Login without a password is forbidden by configuration (see AllowNoPassword)".

If you really have no root password, on a database that's connected to the internet, you really should re-think this situation. As indicated in the error message, you should see the documentation section on AllowNoPassword if you really wish to ignore my advice.

Answer 2

Try

user: Root

pass: Root

Sometimes this auto defaults, it sounds like you deleted your users data on accident.

Refer to: Phpmyadmin doesn't show "privileges" tab If your problems persist.

Answer 3

some hosting companies have a MySQL Databases user option ONLY on your cpanel.