[SOLVED] PHP 5.2.5, Mysql 5.0, IIS6 - Just cannot get this to work

[Cep]

Hello,

 

I used to have on my Win2k3 box, PHP 4.1 and a Mysql 4.1 database server. I decided as I am moving to PHP5 to upgrade Mysql as well.

 

I have removed the previous versions and decided to start from scratch.

 

I have done the following,

 

Installed PHP 5.2.5 and enabled all the extensions, Installed MySQL 5.0 and set a new username and password, I have tested PHP is working using phpinfo() and can see that my php is working and that all the extensions are present.

 

The problem is that when I run a script that uses any mysql functions IIS will continue to return a blank page, in the logs it returns and internal server 500 error (as useful as that is) and nothing else happens.

 

I have checked PHP.ini and e_all is set for my error reporting.

 

The next thing I do is remove my mysql functions from the script and do a simple echo test and I then get a response. When I uncomment the mysql lines, I again get a blank page.

 

I have tried to test this from another server and I now get error messages/notices appear as an output giving me the following,

Unable to connect Client does not support authentication protocol requested by server; consider upgrading MySQL client

 

However I do not understand this because surely if this is a new MySQL installation it should be using the new 41bit hash and this error normally occurs when using an old password?

 

Can anyone help?

[Cep]

I have had to basically reinstall everything in order to get this resolved trying to track an answer down was not as quick if anyone needs instructions these are the best http://www.tjitjing.com/blog/2006/05/php5-with-iis6-on-windows-server-2003.html