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?