Question

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

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

Add a comment
wangtnet
By:
wangtnet
Add a comment

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
asb 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

Reply Report
mike621308 January 5, 2015

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

Reply Report
Submit an Answer

Looking for something else?

Ask a new question Search for more help