Root user login
Hello, I cannot access the database and phpmyadmin with the new (or even the old password) and the sites are down, after I did a root user password reset, following the Linode guide https://www.linode.com/docs/quick-answers/linode-platform/reset-the-root-password-on-your-linode/;
I am confused about what actually a root user in this context is, which I presumed was my login for the database and phpmyadmin. Kindly help.
3 Replies
Hi,
If you followed the instructions to reset-the-root-password-on-your-linode then you probably changed the password for the 'root' account for the Linux operating system. So, if you SSH to your Linode and you login as the 'root' user -- this is the password that was changed.
Your database also has a root account (but the password will most likely be different than the operating system's root account password).
Resetting the password for your database server is usually more complicated and it depends on which database server you're running, but I did find a few articles that might be helpful:
For MySQL:
https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
https://www.techrepublic.com/article/how-to-set-change-and-recover-a-mysql-root-password/
For PostgresSQL:
http://www.postgresqltutorial.com/postgresql-reset-password/
Thanks much for that. I can still log into linux using passphrase; may be I have to revisit it the settings again to get all that right there.
Ok, yes I can log into the database using the old password; but my sites all down and cannot restart apache and cannot access apache log as well. Could you advise why this would occur after password reset? The only thing I did apart from this the pw reset was to set wp-cli.
Thanks again.