i can't connect to mysql. the error is
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Documents and Settings\...
im using the script here in the php tutorial:
$Host = "mysqllocation"; //location of mySQL on server $User = "username"; //my username $Pass = "mypass"; //my password $Name = "db"; //name of the database to be used $Table = "tabledb"; //name of the table within the database mysql_connect ($Host, $User, $Pass, $Name, $Table) or die ("unable to connect to database"); @mysql_select_db("$Name") or die ("unable to select DB"); $sqlquery = "SELECT * FROM $Table WHERE opinion = 'is horrible'"; $result = mysql_query($sqlquery); $number = mysql_num_rows($result);