MySQL Authentication

I’ve just hit the following error:

MySQL Authentication – Authentication with old password no longer supported, use 4.1 style passwords.

This is due to the way passwords are stored in the database for later versions of MySQL. All I needed to do was to reset the password for the user concerned. Just setting the new password as the old password was enough for MySQL to update the password hash, and I could then log in.

Of course, this is only an option if you can log in as a user with sufficient privilege to change the password. Fortunately, I could. Not sure what i’d have done otherwise…

http://www.mysql.com/