By devstrend
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
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!
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
root@ubuntu-16:~# cat /etc/motd.tail cat: /etc/motd.tail: No such file or directory
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
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.