#30586 [NEW]: Connection problems with MySQL 4.1.5 or later

From: olger901 at gmail dot com Operating system: Windows 2000 Server PHP version: Irrelevant PHP Bug Type: MySQL related Bug description: Connection problems with MySQL 4.1.5 or later Description: ------------ Hello all, I am using: Windows 2000 Server Apache 2 PHP 4.3.9 MySQL 4.0.21 (upgraded today to 4.1.7) I recently upgraded to MySQL 4.1.7 However after the upgrade PHP wasn't connecting to MySQL anymore and I can't seem to find the problem. This is the error phpmyadmin gives me: #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client MySQL Administrator connects fine, I turned on old password compatability with it restarted my server and it didn't help a thing. I both tried using PHP 5.0.2 and PHP 4.3.9 but that didn't work either, I also tried replacing the PHP libmysql.dl with the DLL libmysql.dll that came shipped with MySQL 4.1.7 but then php complains that feature drop table isn't supported and that the MySQL extension won't be loaded. With PHP 5.0.2 I also tried using the MySQLi extension but that doesn't seem to work either. -- Edit bug report at http://bugs.php.net/?id=30586&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30586&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30586&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30586&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=30586&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=30586&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=30586&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=30586&r=needscript Try newer version: http://bugs.php.net/fix.php?id=30586&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=30586&r=support Expected behavior: http://bugs.php.net/fix.php?id=30586&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=30586&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=30586&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=30586&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30586&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=30586&r=dst IIS Stability: http://bugs.php.net/fix.php?id=30586&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=30586&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=30586&r=float MySQL Configuration Error: http://bugs.php.net/fix.php?id=30586&r=mysqlcfg