Hi,
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.