如题,我在用PHP连接数据库:
$link = mysql_connect("localhost:3306","root","php");
echo $link."<br>";
$close = mysql_close($link);
echo $close; 出现如下问题,请大侠指教mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in d:\usr\www\html\test.php on line 7
$link = mysql_connect("localhost:3306","root","php");
echo $link."<br>";
$close = mysql_close($link);
echo $close; 出现如下问题,请大侠指教mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in d:\usr\www\html\test.php on line 7
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
其二:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;实际的参数请根据自己的数据进行修改 例如密码之类的
这样做后,连接就会正常了@!