[Resolved] PHP & MYSQL on win 2000 server

[chriswheat]

Hello,

I have php and mysql installed on windows 2000 server.

PHP works fine by its self and can interact with an odbc database.

Mysql works fine by its self and I can use navicat to query the mysql db.

I can not get php to connect to mysql? Any ideas on what might be going on?

$dbhost = "localhost";
$dbusername = "username";
$dbpasswd = "password";
$database_name = 'test';
$connection = mysql_connect("$dbhost","$dbusername","$dbpasswd")or die ("Could not connect to Database.");

The above are the same exact settings I am using in Navicat to connect. What would cause php to not connect?

Many Thanks
Chris

[devinemke]

use [man]mysql_errror[/man] to see what the problem is

[tsinka]

Did you install MySQL 4.0.x or 4.1.x ?

Thomas

[chriswheat]

4.1.x

Thanks
Chris

[devinemke]

read this

[chriswheat]

Since I am on php 4.3.9 this I used msql_error and recieved this error message:
Client does not support authentication protocol requested by server; consider upgrading MySQL client

using this code:

$connection = mysql_connect("$dbhost","$dbusername","$dbpasswd")or die (mysql_error ());

[chriswheat]

Thank you... devinemke

The thread you pointed out was the problem, that was quick.

Chris