Access denied for user 'root'@'localhost' (using password: YES)

Trying: mysqladmin -u root -p flush-hosts I enter the correct root password and get the following:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I need to flush the hosts. How can I do this?

Replies (1)

If that's not working then it seems your password is wrong

Reply 1 2016-04-29

It sounds like you are sure that it's not but I am not aware of any other reason why that command would fail. Do you have a non-US keyboard? Perhaps one of the characters that you are using is not rendering properly?

Regardless, you can reset the MySQL root password by rerunning the MySQL inithook, like this:

/usr/lib/inithooks/bin/mysqlconf.py