#30420 [NEW]: mysql_connect is out of function due to Change of key-length in mysql 4.1.x

From: Date: Wed, 13 Oct 2004 07:38:22 +0000
Subject: #30420 [NEW]: mysql_connect is out of function due to Change of key-length in mysql 4.1.x
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-67524@lists.php.net to get a copy of this message
From: slartibartfass at web dot de Operating system: any PHP version: 4.3.9 PHP Bug Type: MySQL related Bug description: mysql_connect is out of function due to Change of key-length in mysql 4.1.x Description: ------------ on http://dev.mysql.com/doc/mysql/en/News-4.1.1.html the following is stated: - Warning: Incompatible change! Client authentication now is - based on 41-byte passwords in the user table, not 45-byte - passwords as in 4.1.0. Any 45-byte passwords created for - 4.1.0 must be reset after running the - mysql_fix_privilege_tables script. ---------------------------------------------------------- due to this change I can not connect to any mysql-server beyond 4.1.x via PHP/mysql_connect, cause mysql_connect seems to produce 45-Byte-password still.... ...I would appreciate a quick workaround... -- Edit bug report at http://bugs.php.net/?id=30420&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30420&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30420&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30420&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=30420&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=30420&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=30420&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=30420&r=needscript Try newer version: http://bugs.php.net/fix.php?id=30420&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=30420&r=support Expected behavior: http://bugs.php.net/fix.php?id=30420&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=30420&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=30420&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=30420&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30420&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=30420&r=dst IIS Stability: http://bugs.php.net/fix.php?id=30420&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=30420&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=30420&r=float MySQL Configuration Error: http://bugs.php.net/fix.php?id=30420&r=mysqlcfg

« previous php.bugs (#67524) next »