mysqladmin: connect to server at ‘localhost’ failed

Short version: If your MySQL user root needs a password to connect, it might be a good idea to have mysqladmin provide that password 😉 Longer version: Your MySQL user root seems to need a password to connect setting the mysql root password new But mysqladmin tries to connect without a password ‘Access denied for user ‘root’@’localhost’ (using password: NO)’ And mysqladmin does that because you’re not … Read more

MySQL root password change

I found it! I forgot to hash the password when I changed it. I used this query to solve my problem: update user set password=PASSWORD(‘NEW PASSWORD’) where user=’root’; I forgot the PASSWORD(‘NEW PASSWORD’) and just put in the new password in plain text.