mysql problem with apache and php

[dizyn]

Please see this and help me!

thanks in advance...

PHP Code:
<?

mysql_connect("localhost","root","root") or die("Sorry Please ..........");
mysql_select_db("test");
$re = mysql_query("select * from test1") or die(mysql_error());
while($ro = mysql_fetch_object($re))
{
echo $ro->name;
echo "<BR>";
}

?>

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Server\Apache2\htdocs\test.php on line 10
Sorry Please ..........

[jatar_k]

did you figure this out dizyn?

[coopster]

Looks like the old password issue [webmasterworld.com] (see message number 9).

[mcavic]

Yes, it's probably a version mismatch between PHP's MySQL client, and the MySQL server. I got around this problem by installing Apache, MySQL, and PHP from RPM rather than the nightmere of compiling them myself.