Please help, trying to make a connection to database using PHP

reddymade

I am trying to make a connection to the mysql database
using the Enginesite editor for php: on windows 2000 server with IIS (PHP 5.0- mysql4.0):
I am getting the message:
Client does not support authentication protocol requested by server; consider upgrading MySQL client

I am trying to connect to database to see how it works.i am using the following code:
*****************Code*************************
<html>
<head>
<title>New document</title>
</head>
<body>
<?php
$db_host = 'localhost';
$db_name = 'mysql';
$db_user = 'root';
$db_pass = '';
$pconn = 'off';

if($pconn == 'off') {
$db = mysql_connect($db_host, $db_user, $db_pass) or die(mysql_error());
} else {
$db = mysql_pconnect($db_host, $db_user, $db_pass) or die(mysql_error());
}
mysql_select_db($db_name, $db);

?>
</body>
</html>

Thank you very much for the information.

fl0w

Hm, I've never used a windows based mysql/php server.

Heh, did you try upgrading your mysql? 🙂
What mysql version are you running?

Also, the mysql library isn't included by standard in php5.0, you'll have to include ut manually, allthough, that would give a different error message.

reddymade

Hello Flow,
Thank you for your response. I am using mysql verion 4.0

-Raj

fl0w

You can read it @ php.net/mysql, but still, I do not think that's the problem. But I'm on it. As I was saying I'm not familiar with windows based php/mysql servers so I have to do a minor research on it 🙂

Could take some time though, I suggest you do the same, maybe look trough the other boards, search mysql.com, while you're waiting on an eligible answer.