经典ASP MySQL错误的身份验证方法 [英] Classic ASP MySQL Wrong Authentication Method
问题描述
我有一个经典的ASP网站，我刚刚将其上传到另一台服务器，并且出现以下错误:
I have a classic ASP site that I just uploaded to a different server, and it is giving the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client
我尝试做所有建议的事情，包括MySQL官方网站: http://dev.mysql.com/doc/refman/5.6/en/old-client.html
I tried doing what is suggested everywhere including the official MySQL website: http://dev.mysql.com/doc/refman/5.6/en/old-client.html
也就是说，转到mysql.user表并使用OLD_PASSWORD()函数更改密码，然后将plugin值更改为mysql_old_password，并刷新特权.
That is, going to the mysql.user table and changing the password with the OLD_PASSWORD() function, and changing the plugin value to mysql_old_password, and flushing privileges.
由于某种原因，它仍然无法正常工作.
For some reason it still doesn't work.
服务器正在连接到安装了MySQL 5.6的远程MySQL服务器.
The server is connecting to a remote MySQL server with MySQL 5.6 installed.
连接字符串为:
DRIVER={MySQL ODBC 3.51 Driver};SERVER=server_IP;DATABASE=db_name;UID=user_name;PASSWORD=password;OPTION=3;charset=utf8;stmt=SET CHARACTER SET Hebrew;
推荐答案
连接驱动程序应为:DRIVER={MySQL ODBC 5.1 Driver}，因此生成的连接字符串为:
The connection driver should be: DRIVER={MySQL ODBC 5.1 Driver}, therefore the resultant connection string is:
DRIVER={MySQL ODBC 5.1 Driver};SERVER=server_IP;DATABASE=db_name;UID=user_name;PASSWORD=password;OPTION=3;charset=utf8;stmt=SET CHARACTER SET Hebrew;
更新:这是MySQL ODBC驱动程序的列表.您可以获取最新版本&查看发行说明: http://dev.mysql.com/doc/relnotes/connector-odbc/en/
UPDATE Here is a list of MySQL ODBC drivers. You can obtain the latest version & view the release notes: http://dev.mysql.com/doc/relnotes/connector-odbc/en/
这篇关于经典ASP MySQL错误的身份验证方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
