Problem with secure MySQL installation on new droplet

January 9, 2014 4.3k views
paul.alford51
By:
paul.alford51
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.
Log In to Comment
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
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
pablo January 9, 2014
Check out LAMP Stack password.
Reply
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
Have another answer? Share your knowledge.