Question

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

Posted August 20, 2014 8.1k 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?

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

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

Submit an Answer