MySQL DB connection problem

[ingrawc]

When trying to configure a php calendar application we receive the following error:

 

________________________________________________________________________________

There was an error connecting to the mySQL database.

 

The error was reported as:

 

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

________________________________________________________________________________

 

PHP version: 4.4.9

MySql version: 5.1.31

Webserver: IIS v.6

OS: Windows Server 2003 SP1

 

Is this a common error that there is a quick fix for or do we need to do some more upgrading?

 

I can't actually see the PHP as it is protected by Zend Guard, but the company tells me that the connection string is as follows:

<?php

mysql_connect("host", "userName", "password");

?>

 

I also have other connections that us this same db, but use the odbc_connect function instead of mysql_connect.  I've also tried mysql_pconnect to no avail.

 

Thanks,

Chad

[premiso]

You would have to install mysql on the php server. If you are using odbc, then chances are the mysql extension has not been installed.

 

Check the php.ini for the php_mysql extension, uncomment it if it is commented out. I am not too familiar with IIS, so yea. But that is most likely the base of the error.

 

Also make sure you have the actual MySQL database installed (since you posted the mysql version I take it you do).

[socratesone]

This isn't the literal connection strings, I hope?

mysql_connect("host", "userName", "password");

You are passing in the actual values, right? Not the strings "host", "userName", and "password"?

 

[trq]

Your mysql client (php) is too old for that version of mysql. Upgrading php should fix the issue.

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.0/en/old-client.html