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?
Subscribe
Share
Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Sign in to AnswerThese 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.
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?
Try to reset the root user’s access. Run via command.