connect to mysql database

[dipal]

i want to connect the mysql database but i got following error

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Dipal\PHP\fi rst.php on line 9

[mainul]

send me your whole code please

[dipal]

I m totally new to php i just started to check the connectivity option of php with mysql.The code is given below

<?php
$db = mysql_connect(" localhost", "root","dipal") ;
mysql_select_db ("employee",$db );
$result = mysql_query("SE LECT * FROM emp",$db);
printf("First Name: %s<br>\n", mysql_result($r esult,0,"name") );
?>

<?php
$db =mysql_connect( "localhost" , "root","dipal") ;
mysql_select_db ("employee") ;
$result = mysql_query("SE LECT * FROM emp");
$numrows = mysql_num_rows( $result);
print "There are $numrows people in usertable\n";
?>

send me your whole code please