Connecting to MySQL 4.1 with Old Libraries

If you need to connect to a MySQL 4.1 Database using an old mysql library, you need to change the password for the user account that you want to connect with, so that it uses an old password. The new version of the database uses a different password algorithm which is much longer then the old version, which causes problems with the old library. To fix this you have to set the user password with the Old_password( ) function.

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

http://dev.mysql.com/doc/mysql/en/password-hashing.html

Ken Cochrane
02-13-05