Client does not support authentication protocol requested by server; consider upgrading MySQL client
来源:互联网 发布:moka软件下载 编辑:程序博客网 时间:2024/05/20 11:52
在项目开发的时候遇到了MySQL数据库连接采用ODBC方式连接出现“高版本不兼容低版本客户端的问题”,采用“MySQLClient”进行连接出现错误。
错误提示:
ERROR [HY000] [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client
原因是因为使用的mysql服务器版本中使用了新的密码验证机制,这需要客户端的版本要在4.0以上,原来的密码函数被改为old_password ();
这样使用password()生成的密码在旧的版本上的客户端就会出现问题。
目前已知解决方法:(我已经用此办法解决)下载安装
mysql-connector-odbc-3.51.12-win32.msi
错误提示:
ERROR [HY000] [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client
原因是因为使用的mysql服务器版本中使用了新的密码验证机制,这需要客户端的版本要在4.0以上,原来的密码函数被改为old_password ();
这样使用password()生成的密码在旧的版本上的客户端就会出现问题。
目前已知解决方法:(我已经用此办法解决)下载安装
mysql-connector-odbc-3.51.12-win32.msi
- 烦人的问题:Client does not support authentication protocol requested by server; consider upgrading MySQL client
- Client does not support authentication protocol requested by server; consider upgrading MySQL client
- PHPMYADMIN: #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
- #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
- Client does not support authentication protocol requested by server; consider upgrading MySQL Client
- Client does not support authentication protocol requested by server; consider upgrading MySQL client
- MYSQL 新版出现" Client does not support authentication protocol requested by server; consider upgrading MySQL client"解决办法
- [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client
- Mysql 连接提示 Client does not support authentication protocol requested by server; consider upgrading MySQL client 解决方法
- linux解决:Client does not support authentication protocol requested by server; consider upgrading MySQ
- Client does not support authentication protocol requested by server: MYSQL
- 解决:Client does not support authentication protocol requested by server
- Client does not support authentication protocol requested by server;
- MYSQL 错误:Client does not support authentication protocol requested by server;
- MySQL 版本错误处理(Client does not support authentication protocol requested by server)
- MySQL 版本错误处理 (Client does not support authentication protocol requested by server)
- 错误MySQL 返回: #1251 - Client does not support authentication protocol requested by server
- MySQL 版本错误处理 (Client does not support authentication protocol requested by server)
- NTDDI_VERSION,_WIN32_WINNT,WINVER,_WIN32_IE
- java数据结构-HashMap
- ABS 增加分享
- C#设置IE代理
- IOS开发-UIPageControl 分页控件
- Client does not support authentication protocol requested by server; consider upgrading MySQL client
- 对DataSet的数据 用 PagedDataSource 进行分页
- asp.net关于时间方法,当前月有多少天、求某年有多少周、求当前日期是一年的中第几周
- Oracle中EXECUTE IMMEDIATE的使用技巧
- MySQL和PostgreSQL的比较
- VMWare
- Java基础_常用类_StringBuffer
- Linux下进程信息的深入分析
- 2013年-华为面经新鲜出炉