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.

×
2 answers

Hey,

Usually with the 1-Click installs, the passwords are saved to a file when the droplet is created. Try having a look for any .password files in the root directory. I’ve just created a new droplet and the passwords are at ‘root/.digitalocean_password’ so that may be worth a try.

Hope this helps,
Mike

Hello, @ScoutDigital

As per @mchlbwyr reply you need to check the file in order to obtain the MySQL credentials. You can also double check the information provided in the one-click LAMP page as well:

https://marketplace.digitalocean.com/apps/lamp

The MySQL root password is in /root/.digitalocean_password

Regards,
Alex

Submit an Answer