MySql密码验证 [英] MySql Password Authentication

问题描述

c# authentication with old password no longer supported use 4.1 style passwords

我收到此错误，我正在使用带有mysql数据库的C＃。

I am getting this error, I am using C# with mysql database.

推荐答案

这更新版本的MySQL会出现错误，因为它们已使用较新版本更改了身份验证机制。您可以将MySQL服务器密码升级为新密码格式，或者在服务器的'my.ini - 文件中设置

This error comes with the newer versions of MySQL because they have changed the authentication mechanism with the newer versions. Either you upgrade the MySQL Server passwords to the new password format or set

old_passwords=1

。我会说升级密码将是更好的选择，但你决定。



附加信息：

http://stackoverflow.com/questions/13706463/authentication-method-mysql-old-password-not -supported [ ^ ]

http://stackoverflow.com/questions/14960136/mysql-how-to-upgrade-all-client-programs-to-use-a-4-1-1 [ ^ ]



欢呼，

Marco Bertschi

in the seervers'' my.ini - file. I''d say upgrading the password will be the better option, but you decide.

Additional information:
http://stackoverflow.com/questions/13706463/authentication-method-mysql-old-password-not-supported[^]
http://stackoverflow.com/questions/14960136/mysql-how-to-upgrade-all-client-programs-to-use-a-4-1-1[^]

cheers,
Marco Bertschi

这篇关于MySql密码验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！