Question
Cannot log in to phpMyAdmin with MariaDB root user
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?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
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?
This comment has been deleted
Is that after logging in to MariaDB on the command line?