12/12/2005
Force MySQL 4.1 to Use Old Style Passwords
MySQL 4.1 uses a new password hashing schema that translates passwords to a forty character hash instead of the previous version’s sixteen characters. If you upgrade MySQL and don’t rebuild PHP using the updated libraries, PHP applications won’t be able to authenticate properly. A quick (and temporary) fix, is to force MySQL to use the old password hashing schema until PHP can be rebuilt.
Add this to your my.cnf in the [mysqld] section:
# Default to using old password format for compatibility with pre 4.1 clients
old_passwords=1
old_passwords=1
More information on the MySQL site.
Popularity: 13%
