mysql_connect() 連線問題

如果你最近安裝了MySQL，想要從php連線時出現下面的錯誤訊息:

mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client

(我是安裝plog時要連接MySQL時出現的)
參考下面討論區的解法有二:
1. 針對你要連結的User在mysql console底下執行(當然username/localhost要改成你要的)

SET PASSWORD FOR username@localhost = OLD_PASSWORD('something');

2. 或是修改my.ini以下的設定

#Use old password encryption method (needed for 4.0 and older clients).
old_passwords

猜測應該是新版MySQL的密碼編碼方式有改，而一些Client library還沒更新吧。
http://forums.mysql.com/read.php?11,6400,6400