Cannot log in to phpMyAdmin with MariaDB root user

Posted August 29, 2015 16.1k views

I have used the TuxLite scripts to setup my Ubuntu 14.04 server. All has been working fine for weeks until now.

I can not log in to phpMyAdmin with the root user. However other users previously created can still access their databases. However I can log in to MariaDB using the root user from the command line.

I’m not sure what I have done to cause this, or whether something changed when I ran my weekly apt-get update/upgrade.

Does anyone have any possible solutions to my problem?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
4 answers

Try to reset the root user’s access. Run via command.

GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY ' your current password ' WITH GRANT 

Is that after logging in to MariaDB on the command line?

In the end I did a database dump, uninstalled MariaDB, cleared out all the data stores for the tables, and then reinstalled MariaDB, and imported the databases.

I then exported each database individually, and created a new user/database for each database using the MariaDB root account on phpMyAdmin. Once I had gone through all the databases and successfully reimported each the them and made sure that each one was working correctly, I took a DO snapshot of the server.

However once the server came back online, that was when the MariaDB root user stops being able to login through phpMyAdmin. I can still login to MariaDB using the commandline, but not through phpMyAdmin.

I even attempted to run the above command, but I still cannot login to MariaDB using root on phpMyAdmin.

Further thoughts?