Related

Problem installing wordpress on subdomain (nginx / ubuntu) Question Question
GUI for MongoDB needed to mange Meteor app Question Question

Question

Cannot log in to phpMyAdmin with MariaDB root user

Posted August 29, 2015 15k views
UbuntuMariaDBLEMP

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?

Add a comment
itsonlybarney
By:
itsonlybarney

Related

Problem installing wordpress on subdomain (nginx / ubuntu) Question Question
GUI for MongoDB needed to mange Meteor app Question Question

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.

×
3 answers
MrPeppah August 29, 2015

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
Reply Report
itsonlybarney August 29, 2015

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

Reply Report
michele314 August 29, 2015
[deleted]
Reply Report
itsonlybarney August 29, 2015

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?

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help