Power up with new SaaS Add-Ons from the DigitalOcean Marketplace

Question

ERROR 1045 (28000): Access denied for user 'root'@'localhost'

  • Posted October 14, 2014

Hi, I had created a droplet with Ubuntu 14.04 and LEMP as application. After completing I had tried this command to secure mysql sudo /usr/bin/mysql_secure_installation and when ask for password I had made enter as I do not know root password. Its saying ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’. I had tried to install phpmyadmin same problem there. I am now unable to use my droplet. How to use mysql after creating a drplet with LEMP application? Please help. Thanks

Subscribe
Share
Submit an 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.

Andrew SB • October 14, 2014

A random password is generated for the MySql root user. When you logon to the console of a LEMP one-click droplet, you should see something like:

-------------------------------------------------------------------------------------
Thank you for using DigitalOcean's LEMP Application.
Your web root is located at /usr/share/nginx/html and can be seen from http://XXX.XXX.XX.XX/
The details of your PHP installation can be seen at http://XXX.XXX.XX.XX/info.php
Your MySQL root user's password is txetdmRqpZ
You are encouraged to run mysql_secure_installation to ready your server for production.
-------------------------------------------------------------------------------------

If you need to see the password again, run: cat /etc/motd.tail

Andrew SB • October 14, 2014

A random password is generated for the MySql root user. When you logon to the console of a LEMP one-click droplet, you should see something like:

-------------------------------------------------------------------------------------
Thank you for using DigitalOcean's LEMP Application.
Your web root is located at /usr/share/nginx/html and can be seen from http://XXX.XXX.XX.XX/
The details of your PHP installation can be seen at http://XXX.XXX.XX.XX/info.php
Your MySQL root user's password is txetdmRqpZ
You are encouraged to run mysql_secure_installation to ready your server for production.
-------------------------------------------------------------------------------------

If you need to see the password again, run: cat /etc/motd.tail

Andrew SB • October 14, 2014

A random password is generated for the MySql root user. When you logon to the console of a LEMP one-click droplet, you should see something like:

-------------------------------------------------------------------------------------
Thank you for using DigitalOcean's LEMP Application.
Your web root is located at /usr/share/nginx/html and can be seen from http://XXX.XXX.XX.XX/
The details of your PHP installation can be seen at http://XXX.XXX.XX.XX/info.php
Your MySQL root user's password is txetdmRqpZ
You are encouraged to run mysql_secure_installation to ready your server for production.
-------------------------------------------------------------------------------------

If you need to see the password again, run: cat /etc/motd.tail

JaberAlNahian • May 27, 2018

root@ubuntu-16:~# cat /etc/motd.tail cat: /etc/motd.tail: No such file or directory