Error Connecting PHP-mySql

johnbest

Hello friends

I am newbie to PHP and mySql..
I have intalled mySql 4.1 for Nt on XP.
Also created a database and a table...now wants to
connect it using PHP (version - available with FOXSERV)
Following os my code :

<html>
<body>
<?php
$user="root";
$password="anand";
$database="calendar";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
?>
</body></html>

But unable to connect..following is the error message which i got:

Warning: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\FoxServ\www\mutualfund\connNsql.php on line 7

Warning: MySQL Connection Failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\FoxServ\www\mutualfund\connNsql.php on line 7
Unable to select database

what does this mean? please help me ....

kiwibrit

Hi. I am new to all this myself, but - until one of gurus arrives, you might like to try this for yor connection lines:

$dbh = mysql_connect($hostname, $username, $password) 
	or die("Unable to connect to MySQL");
mysql_select_db("yourdatabase") or die ("Unable to select database!");

Rodney_H_

Here, you may need to read this article for the answer: http://dev.mysql.com/doc/mysql/en/old-client.html

I hope it helps . . .

johnbest

thanks a lot

Rodney