MySql Error > Can't log in
 

MySql 3.23.58 on FC1 was running fine until something (what?) changed and now I can't login to "mysql>". The error message is "ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)". Which will come up regardless of whether I log in using a password or, regardless of using root or some other user. If I add "skip-grant-tables" to my "/etc/my.cnf" then I can get in.

Any ideas?

Try this from the mysql command line:

SET PASSWORD FOR
'some_user'@'some_host' = OLD_PASSWORD('newpwd');

It's worked on every MySQL database I've had that problem on.