PHP连接MYSQL问题！！！

[34909521]

我现在用的是PHP最新5.X，MYSQL和APACHE，
完成各种设置后可以访问PHP的页面，比如<? echo phpinfo(); ?>

现在用下列代码连接数据库测试，结果就报错
<?php
$link=mysql_connect('localhost','root','123456');
if(!$link) echo "fail";
else echo "success";
mysql_close();
?>

错误：
Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in G:\php\index.php on line 2
fail
Warning: mysql_close(): no MySQL-Link resource supplied in G:\php\index.php on line 5

[34909521]

4.17

[fzjw]

mysql>set password for 'root'@'localhost' = old_password('newpassword');

[fzjw]

或者加入mysqli扩展
修改php.ini，在extension那里加入
extension=php_mysqli.dll
然后复制libmysqli.dll到System32或者Apache2的bin目录（Apache1.3.x的根目录）下，重启后用以下代码测试连接：
<?php
$host = "localhost";
$user = "root";
$passwd = "123456";
$dbname = "test";

$mysqli = new mysqli($host,$user,$passwd,$dbname);

if (mysqli_connect_errno()) {
print("连接数据库失败！");
exit;
}
?>

[speakboy]

你的MySQL版本是什么