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
some hosting companies have a MySQL Databases user option ONLY on your cpanel.
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.
Depending on your phpMyAdmin version, the “Privileges” tab has been renamed to “User accounts”.
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.