Report this

What is the reason for this report?

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

Posted on 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?



This textbox defaults to using Markdown to format your 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.

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

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

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.