No privileges in phpmyadmin

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)”.

Read More

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

Related posts

Leave a Reply

3 comments

  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.