Power up with new SaaS Add-Ons from the DigitalOcean Marketplace

Question

What's the initial root password of mysql ? I choose the lemp environmental.

  • Posted August 20, 2014

root@solver:/usr/share/nginx/html/question2answer# /usr/bin/mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)

where I can find the root password of mysql?

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

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.

Andrew SB • August 20, 2014

When you log into the server, you will see the following in the “message of the day.”

-------------------------------------------------------------------------------------
Thank you for using DigitalOcean's LEMP Application.
Your web root is located at /usr/share/nginx/html and can be seen from http://142.593.1.37/
The details of your PHP installation can be seen at http://142.593.1.37/info.php
Your MySQL root user's password is dcC0IT4afb
You are encouraged to run mysql_secure_installation to ready your server for production.
-------------------------------------------------------------------------------------
To delete this message of the day: rm -rf /etc/motd.tail

Your MySql root user’s password will be there. To show the message again, run cat /etc/motd.tail

Andrew SB • August 20, 2014

When you log into the server, you will see the following in the “message of the day.”

-------------------------------------------------------------------------------------
Thank you for using DigitalOcean's LEMP Application.
Your web root is located at /usr/share/nginx/html and can be seen from http://142.593.1.37/
The details of your PHP installation can be seen at http://142.593.1.37/info.php
Your MySQL root user's password is dcC0IT4afb
You are encouraged to run mysql_secure_installation to ready your server for production.
-------------------------------------------------------------------------------------
To delete this message of the day: rm -rf /etc/motd.tail

Your MySql root user’s password will be there. To show the message again, run cat /etc/motd.tail

mike621308 • January 5, 2015

Is there a way to recover this if you’ve deleted /etc/motd.tail