PHP加MySQL出现如下错误，请看看！如何解决

[liuzhitang]

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in D:\php\Liusy\db_connect.inc.php on line 16

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in D:\php\Liusy\db_connect.inc.php on line 18
Client does not support authentication protocol requested by server; consider upgrading MySQL client


<?php
//数据库所在的主机地址，loclahost是本机地址
$MYSQL_HOSTNAME="localhost";
//登陆数据库的用户名称
$MYSQL_USERNAME="root";
//登陆数据库的密码
$MYSQL_PASSWORD="123456";
//要登陆的数据库的名称
$DATABASE="myshop";
//所有要登陆的用户名表
$USER_LOG_TABLE="user_login";
//数据库的连接操作
$link=mysql_connect("localhost","root","123456");
mysql_select_db("myshop",$link) or die(mysql_error());
?>

[ice_berg16]

google搜索

Client does not support authentication

一堆一堆的答案

[stefenjun]

$link=mysql_connect("$MYSQL_HOSTNAME","$MYSQL_USERNAME","$MYSQL_PASSWORD");

[oldbiestar]

你的MySQL版本太新，但是你的PHP版本太旧，需要升级了……

或者在MySQL里面设置使用旧式的密码……