I'm completely confused with the CentOS's mysql server. It's 5.0.77 from CentOS 5.5.
I can't seem to create a user on that server. I've disabled the old_password option and restarted. I created a new user with:
GRANT SELECT ON db.table TO username IDENTIFIED BY 'some password';
It was correctly hashed to the new type password in mysql.user... but every time I try to login (either over socket, or network) I get:
ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: YES)
I've never had problems with that in any other distro. Is there something centos-specific in the standard mysql package? How can I fix this situation?