MySQl 4.1.7 & PHP 5.0.2 on IIS 5

[binarydumb]

Hello all.

I need a little help. I am installing on Win XP Pro, MySQL 4.1.7, PHP 5.0.2, and IIS 5.1 (comes with XP Pro). I can view plain HTML's through my browser but am having trouble with MySQL and PHP5 communicating.

When I execute "<?php phpinfo(); ?>" from my browser, I get the PHP version and info, etc. So I gather that my PHP5 installation is OK.

But when I try to connect to my SQL via PHP5 with:
"<?php $connection = mysql_connect( "localhost", "root", "pass+word" )
or die( "Sorry - unable to connect to MySQL" );
echo( "Congratulations - you connected to MySQL" );"

I get the following error:

" Sorry - unable to connect to MySQLPHP Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\WWW\mysqltest.php on line 11"

What am I doing wrong?

Help, please.........

:blink: :unsure:

Thanks in advance.

Tony

[strasm]

If this is not solved there is some things you need to check. First of all let me say that I hate running php on windows, we do it at work on a server, but i didnt set it up. When installing PHP on Linux, it checks to see if you have mysql installed and will install it's self with support for mysql. In other words you must install mysql before you install php. To check to see if you have mysql support in your php installation, check the page genrated by phpinfo();.

Let me know if this is still an issue.

[nicedreams242]

You need to make sure the MySQL client DLL libraries on your system. If you downloaded the ZIP files and not the self extractor. There will be a file named libmysql.dll place this in your SYSTEM32 directory.

[littlesix]

Please run this command after you create an account for your MySQL Server:
mysql> SET PASSWORD FOR 'USER_NAME_YOU_DEFINE'@'localhost' = OLD_PASSWORD('USER_PASSWORD_YOU_IDENTIFY');

Because the authentication protocol which used by MySQL4.1 and later version does not support the older client.