Client does not support authentication

I had an unfortunate incident installing SP2.

I had to reload my distribution disk of XP Professional and then re-apply SP
2.

I then activated IIS
Then installed php (php-5.0.2-installer)
I then installed MySQL (mysql-4.1.7-essential-win)

I then uncommented the MySQL extention in PHP.INI (extension=php_mysql.dll)

I have rebooted numerous times.

I then tried to web access MySQL (no old database) and got the message

Warning: PHP Startup: Unable to load dynamic library ‘./php_mysql.dll’ – the
 specified module could not be found.

Then in the browser I got

Fatal error: Call to undefined function mysql_connect() in

I then copied  libmySQL.dll from Program files/MySQL/MySQL Server 4.1/bin to
 windows/system32

I got the same error.

I then copied  libmySQL.dll from PHP and got the following error

Warning: mysql_connect() [function.mysql-connect]: Client does not support a
uthentication protocol requested by server; consider upgrading


Any help would be appreciated.

Check:
http://dev.mysql.com/doc/mysql/en/Old_client.html


Z.

quote:
Originally posted by aurelius 
Check:
http://dev.mysql.com/doc/mysql/en/Old_client.html


Z. 
 

I have installed

  mysql-4.1.7-essential-win.msi
  php-5.0.2-installer.exe

I never had an earlier version of MySQL or PHP on this system since I had to
 rebuild it from scratch.
I took all the default options.
I did have to use the PHP version of LIBMYSQL.DLL (it was 228K in size)

I then issued the following commands through the web browser.

  echo mysql_get_client_info();
 phpinfo();

For MySQL I get  3.23.57 (this bothers me since I expected 4.1.7)
and PHP was at 5.0.2

The old password issue should not be a problem since I did not restore my da
tabase. I started from scratch.

[QUOTE]Originally posted by aurelius 
Check:
http://dev.mysql.com/doc/mysql/en/Old_client.html


Z. [/QUOTE

I finally solved my problem.

I found a link on the web for an early download of PHP 5.0.3
I made sure to move the new LIBMYSQL.DLL and MYSQL_PHP.DLL
to the windows/system32 folder.

I know it would be better to change the system path but since I don't know h
ow to do that the system32 folder is the next best thing.

PHP 5.0.3 amd MySQL 4.1.7 now get along just great.

Gerd I hope you come back because if you have that link for php 5.0.3 I sure
 could use it.  I need it for a client site that is not working and I've don
e everything that all other forums have suggested.  I'm running php 5.0.2 an
d MySQL 4.1.7 and I keep getting "Client does ..." same as always.  So now I
'm out of options and low on time.

quote:
Originally posted by Wiz 
Gerd I hope you come back because if you have that link for php 5.0.3 I sure could use i
t.  I need it for a client site that is not working and I've done everything that all ot
her forums have suggested.  I'm running php 5.0.2 and MySQL 4.1.7 and I keep getting "Cl
ient does ..." same as always.  So now I'm out of options and low on time. 
 

I hope this helps.

Additional note: php-5.0.3-dev and newer ships with a newer version of the m
ysql library which does not have this problem. You can download it
at: http://snaps.php.net/win32/php5.0-win32-latest.zip