PHP MySQL connection error

[dge_475]

Hi,

I thought I have successfully installed MySQL on my machine until this another error occur:

Error: 1251 SQLSTATE: 08004 (ER_NOT_SUPPORTED_AUTH_MODE)
Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client

whenever I tried to run this script from PHP:

<?php
$link = mysql_connect('localhost', 'root', 'nic');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

I hope somebody could help me on this, thnkx

[cdwhalley.com]

I found this on the mysql docs:
link

If you have PHP 5 installed, it looks like you could try using mysqli_connect() as supposed to mysql_connect(), although this is what I'm getting from the docs page - I've never encountered this error myself