我的配置環境:Win2003+IIS+PHP4.4.8+Mysql4.1.15
PHP和Mysql各個獨立使用都可以正常使用,但用PHP連接Mysql就會出現錯誤:
以下程式碼:
<?php
if(!$link=mysql_connect("localhost","root","999999"));
{
print("connect database error!");
}
?> 以下是出現的錯誤:
Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in D:\Server\www\Test_mysql.php on line 2麻煩那位大俠幫忙指點一下,謝謝!!!!
PHP和Mysql各個獨立使用都可以正常使用,但用PHP連接Mysql就會出現錯誤:
以下程式碼:
<?php
if(!$link=mysql_connect("localhost","root","999999"));
{
print("connect database error!");
}
?> 以下是出現的錯誤:
Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in D:\Server\www\Test_mysql.php on line 2麻煩那位大俠幫忙指點一下,謝謝!!!!
2、更改MYSQL的用户密码
比如:
set password for 'user1'@'%' = old_password('你的密码');
set global old_passwords=on;
set password for 'root'@'localhost' = old_password('999999');
flush privileges;