[rezdog]

I've just upgraded to mysql 4.1.1. I am having problems connecting to the database whenever I use a user with a password. I've tried setting the password with the password function and the old_password function, and neither works for me. I get the same error from both the mysql client, and when trying to connect with the JDBC drivers. The error message I recieve is:
ERROR 1045 (28000): Access denied for user: 'artsys'@'localhost' (Using password: YES)

When I remove the password with the same user, I have no problems with the MySQL client, but I still have the same problem with the JDBC drivers. Anyone had a similar problem?

Scott

[Mincer]

Did you install/start mysql using --old-passwords, or just use the oldpassword() function when hashing the passwords?

[omiossec]

Did you add your user with % as host ?

[rockysoon]

first add new user "with grant option"
then use the instruction "flush prilvileges"
or you will get the "ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password:NO)"