By paulalford51
Hi,
I just spun up a new droplet with a pre-config Ubuntu LAMP stack, then logged in as root fine. Changed root passwd and ran the following.
apt-get update mysql_install_db mysql_secure_installation
After entering the root password I get the following message:
Enter current password for root (enter for none): ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)
This has never happened before on any droplet I have created and used. Any pointers much appreciated.
Thanks in advance.
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!
OK, managed to get in by doing the following: <br> <br>mysql -u debian-sys-maint -p <br> <br>update user set password=password(‘yourpassword’) where user=‘root’; <br>flush privileges; <br>exit <br> <br>Still not sure why there was a problem originally. Is this an issue with droplet creation script at DO end?
Just in case anyone else is getting the same issue debian-sys-maint password can be found by issuing this command: <br> <br>cat /etc/mysql/debian.cnf
Check out <a href=“https://www.digitalocean.com/community/questions/lamp-stack-password”>LAMP Stack password</a>.
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.