Subject: | MySQL 4.1+ Password Incompatibility |
DBI->connect fails with standard MySQL 4.1+ passwords. MySQL's OLD_PASSWORD must be used to set user passwords through MySQL for DBI to connect. This means less secure passwords for MySQL -- 41 byte hashes instead of 45 byte hashes.
Please see the following MySQL manual sections for more information:
"5.6.9 Password Hashing in MySQL 4.1"
http://dev.mysql.com/doc/mysql/en/password-hashing.html.
"5.6.9.1 Implications of Password Hashing Changes for Application Programs"
http://dev.mysql.com/doc/mysql/en/application-password-use.html
"5.6.9.2 Password Hashing in MySQL 4.1.0"
http://dev.mysql.com/doc/mysql/en/password-hashing-4-1-0.html