dneufeld
By:
dneufeld

What root MySQL password is assigned when creating a new droplet using the "LAMP on Ubuntu 14.04" with SSH key

August 21, 2014 1.8k views

What root MySQL password is assigned when creating a new droplet using the "LAMP on Ubuntu 14.04" with SSH key

2 comments
  • I get the following error:

    cat: /etc/motd.tail: No such file or directory
    

    How do I find out or reset MySQL password?

  • When you SSH into your server via Terminal it actually displays your MySQL password as part of the welcome message. There is also a guide on Digital Ocean for resetting your MySQL root password if you really need it. Good luck!

2 Answers

When you first log onto the server via SSH, you should see something like:

-------------------------------------------------------------------------------------
Thank you for using DigitalOcean's LAMP Application.
Your web root is located at /var/www/html and can be seen from http://108.131.197.65/
The details of your PHP installation can be seen at http://108.131.197.65/info.php
Your MySQL root user's password is vmZpCJtyE3
You are encouraged to run mysql_secure_installation to ready your server for production.
-------------------------------------------------------------------------------------

If you need to see the message again, run: cat /etc/motd.tail

Have another answer? Share your knowledge.