When I attempt to run:
sudo mysql -uroot -p
and enter my password, I am prompted with the following error message:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
I've deleted and rebuilt my droplet twice now thinking I fat-fingered the password when I changed it using this command:
sudo mysqladmin -u root -p'password' password mynewpassword
I've tried the purge option from this page:
but it must not be clearing the password as it fails to set the new password when I re-install mySQL.
I also tried the reset a root password section from this page:
but when I run this command:
sudo mysqld_safe --skip-grant-tables &
it appears to hang.
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.