[ASP.NET][MySQL] .net的connector 錯誤 Authentication with old password no longer supported, use 4.1 style passwords.

.net的connector 錯誤訊息
Authentication with old password no longer supported, use 4.1 style passwords.

 MysqL Connector/NET 6.6.x (as of 6.6.2) dropped support for old password style authentication (it was deprecated due to being insecure and there were documented ways to attack it).
.net的connector 已經拋棄了舊的密碼方式, 只支援新的密碼方式.
所以導致.net 新舊格式不一，所以連不上



執行以下指令

SET SESSION old_passwords=0;

SET PASSWORD = PASSWORD('[your password]');

如仍有問題，
請參考使用安全模式下執行動作並更新密碼即可
http://compilerok.blogspot.tw/2013/08/mysql-root.html#more