ID: 30586 User updated by: olger901 at gmail dot com Reported By: olger901 at gmail dot com Status: Open Bug Type: MySQL related Operating System: Windows 2000 Server PHP Version: Irrelevant New Comment:
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. Simply said: The problem is in libmysql.dll in combination with php, because as soon as I upgrade libmysql.dll in C:\WINNT and I restart Apache with php it gives an error about not supporting certain features, while it does, so please upgrade PHP to support MySQL 4.1 versions Previous Comments: ------------------------------------------------------------------------ [2004-10-27 17:01:10] olger901 at gmail dot com 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 this bug report at http://bugs.php.net/?id=30586&edit=1
