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

August 20, 2014 7k views

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?

2 Answers

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

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

Have another answer? Share your knowledge.