Hi There, I inherited a 1Click LAMP install on a droplet that was created 3 years ago. I need to move the db off the droplet for a number of reasons but I don’t know the credentials to login to mySQL or the db username and passwords.
I can access via SSH fine. I have FTP access and can view the site config files which do have the DB name and user/pass (according to wordpress) but that doesn’t seem to be working to dump.
When I log in and run
mysql -u root -p
and using passwords like ‘root’, ’ ’ & my ssh password I’m being declined.
How do I find this out? I’ve found numerous posts on this issue in Digital Ocean including those which tell me my password in included in the MOTD when I log in. Here’s my welcome screen after loggin in via SSH
root@XXX.XX.XX.XXX's password: Welcome to Ubuntu 16.04.3 LTS (GNU/Linux 4.4.0-150-generic x86_64) * Documentation: https://help.ubuntu.com * Management: https://landscape.canonical.com * Support: https://ubuntu.com/advantage Get cloud support with Ubuntu Advantage Cloud Guest: http://www.ubuntu.com/business/services/cloud 251 packages can be updated. 10 updates are security updates. New release '18.04.4 LTS' available. Run 'do-release-upgrade' to upgrade to it. You have new mail. root@neville-clients:~#
You can see password is empty. I have tried an empty password logging into mySQL without success. What can I do to access to the DB/mySQL ?
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.