Client does not support authentication protocol

如果您的php連接資料庫的函式是

mysql

那妳在連線 MySQL 4.1.1 版本或是更高版本~~會出現錯誤訊息

Client does not support authentication protocol requested
by server; consider upgrading MySQL client

所以要改用

mysqli

來連線~~~~~~~~可是如果您的php沒有支援到mysqli

就查詢以下指令

SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host = 'some_host'
AND User = 'some_user';

FLUSH PRIVILEGES;

查詢這三段SQL語法之後~~~妳就可以用該帳號密碼登入4.11版本以上的Mysql經由php的mysql函式


會搞到這東西~~~因為研發處的網頁........@@

資料來源: http://dev.mysql.com/doc/refman/5.0/en/old-client.html