Root user login

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.

Hi,
Well, there some other issues affecting the sites I noticed, so have reverted them back to the previous state and will get the db pwd changes set up separately as you have suggested.
Cheers