wangtnet
By:
wangtnet

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

August 20, 2014 4.8k 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.