php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #30586 Connection problems with MySQL 4.1.5 or later
Submitted: 2004-10-27 17:01 UTC Modified: 2004-11-06 06:53 UTC
Votes:5
Avg. Score:4.8 ± 0.4
Reproduced:3 of 4 (75.0%)
Same Version:2 (66.7%)
Same OS:2 (66.7%)
From: olger901 at gmail dot com Assigned:
Status: Not a bug Package: MySQL related
PHP Version: Irrelevant OS: Windows 2000 Server
Private report: No CVE-ID: None
View Developer Edit
 [2004-10-27 17:01 UTC] 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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-10-27 18:36 UTC] 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-29 04:16 UTC] zerr11ty at uregina dot ca 
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
 [2004-11-04 11:12 UTC] tony2001@php.net 
This problem (and it's solution) is described here: http://dev.mysql.com/doc/mysql/en/Old_client.html
 [2004-11-06 06:53 UTC] edink@php.net 
Additional note: php-5.0.3-dev and newer ships with a newer version of the mysql library which does not have this problem. You can download it at: http://snaps.php.net/win32/php5.0-win32-latest.zip
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Dec 26 13:01:30 2024 UTC