View Full Version : mysql_secure_installation issues

05-11-2011, 04:46 PM
This is the first time I've tried setting up a mysql server so bare with me...

After installation, and starting the mysqld service I've run mysql_secure_installation. However I can't get past step 2, removing the anonymous user.

As soon as I confirm the removal I'm get the following error..

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

I can still login to root using 'mysql -u root -p'

But if I try running mysql_secure_installation again to finish it off then it won't accept the password for root and I can't login...

Any suggestions I'm confused as to why it won't let me finish the secure installation.

Thanks in advance

05-11-2011, 11:44 PM

This problem happens when you try using a hash in the password.. using a password without a hash stops this from happening.