Question

Problem with secure MySQL installation on new droplet

Posted January 9, 2014 4.6k views
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.
Add a comment
paul.alford51
By:
paul.alford51
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.

4 answers
paul.alford51 January 9, 2014
OK, managed to get in by doing the following:

mysql -u debian-sys-maint -p

update user set password=password('yourpassword') where user='root';
flush privileges;
exit

Still not sure why there was a problem originally. Is this an issue with droplet creation script at DO end?
Reply Report
paul.alford51 January 9, 2014
Just in case anyone else is getting the same issue debian-sys-maint password can be found by issuing this command:

cat /etc/mysql/debian.cnf
Reply Report
pablo January 9, 2014
Check out LAMP Stack password.
Reply Report
paul.alford51 January 9, 2014
Hmm, maybe I installed my LAMP stack manually before, but never once had this error message. Thx for the pointer though.
Reply Report
Submit an Answer

Looking for something else?

Ask a new question Search for more help