Question

MySQL root password

Hi,

I just created a new droplet and used the “LAMP on Ubuntu 12.04” application to set it all up and have LAMP installed automatically. Works great, but when I want to install phpmyadmin, it asks for the MySQL password. I tried several options like “root” or empty, but it doesn’t work. Where can I find the password for MySQL? Thanks!

Show comments

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

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.

When you install a LAMP droplet in digitalOcean this is the code to get your mysql password cat /root/.digitalocean_password

Log in and like this answer so that it can get to the top

If you installed LAMP ubuntu or whatever flavour of Linux that just cat the motd message to find the password (why put it here i wonder???) <br>root@domain:/var/www# cat /etc/motd.tail <br>------------------------------------------------------------------------------------- <br>Thank you for using DigitalOcean’s LAMP Application. <br>Your web root is located at /var/www/html and can be seen from http://xxx.xxx.xxx.xxx/ <br>The details of your PHP installation can be seen at http://xxx.xxx.xxx.xxx/info.php <br>Your MySQL root user’s password is XXXXXXXXXX <br>You are encouraged to run mysql_secure_installation to ready your server for production. <br>------------------------------------------------------------------------------------- <br>To delete this message of the day: rm -rf /etc/motd.tail

STOP all and read >> If you installed LAMP ubuntu or whatever flavour of Linux that just cat the motd message to find the password (why put it here i wonder???) root@domain:/var/www# cat /etc/motd.tail