#25462 [NEW]: mysql_connect() password not compatible with MySQL 4.1.x stronger passwords

From: sitbon at pdx dot edu Operating system: RedHat 9/MySQL 4.1.0 PHP version: 4.3.2 PHP Bug Type: MySQL related Bug description: mysql_connect() password not compatible with MySQL 4.1.x stronger passwords Description: ------------ When PHP attempts to connect to MySQL, the password hash is calculated based on MySQL v3.x, but the newer versions (4.1.x) use a stronger password hash, and so the connection is refused on grounds of a bad password, regardless of correctness. Blank passwords still work, and running MySQL with --old-passwords works, but when changing the password with a MySQL 4.1.x client, the hash is again incompatible with PHP. The --old-passwords flag only affects the PASSWORD() command, and apparently the MySQL client does not use it to set the hash. Reproduce code: --------------- n/a Expected result: ---------------- n/a Actual result: -------------- n/a -- Edit bug report at http://bugs.php.net/?id=25462&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=25462&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=25462&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=25462&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=25462&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=25462&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=25462&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=25462&r=support Expected behavior: http://bugs.php.net/fix.php?id=25462&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=25462&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=25462&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=25462&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=25462&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=25462&r=dst IIS Stability: http://bugs.php.net/fix.php?id=25462&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=25462&r=gnused