連接數據庫出現 ------------------------------------------------------------------------------------------- client does not support authentication protocol requested by server; consider upgrading mysql client ------------------------------------------------------------------------------------------- 由于mysql 4.1版本開始密碼的hash算法改變,所以連接數據庫 時可能會出現client does not support authentication protocol問題。
可以通過一下兩種方法解決 其一: 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;