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

ID: 30586 Comment by: zerr11ty at uregina dot ca Reported By: olger901 at gmail dot com Status: Open Bug Type: MySQL related Operating System: Windows 2000 Server PHP Version: Irrelevant New Comment: I have this exact same problem. I believe the problem is with the mysql client that is bundled internally with php 4. It is used instead of the client that comes with the mysql installation. I have heard of a solution that involves building php with the --with-mysql=[DIR] option, where DIR points to the mysql install path. Then PHP will use mysql's clients instead of the bundled ones Previous Comments: ------------------------------------------------------------------------ [2004-10-27 18:36:54] olger901 at gmail dot com 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 ------------------------------------------------------------------------ [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