---------------------------------------华丽的分割线-----------------------------------------
问题描述:
mysql5.0与mysqlodbc3.51建立连接:无法建立一个访问“mysql"数据库的系统dsn。(root帐号密码都没错,”cmd”下可以正常登录)
测试数据原时有错误提示:
[MySQL][ODBC
3.51 Driver] Client does not support authentication protocol requested by
server;consider upgrading MySQL client
解决办法:
SET PASSWORD FOR 用户名@localhost = OLD_PASSWORD('密码');
以下为官方说明:
写道
A.2.3 Client does not support authentication protocol
MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1, attempts to connect to it with an older client may fail with the following message:
shell> mysql
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
To solve this problem, you should use one of the following approaches:
Upgrade all client programs to use a 4.1.1 or newer client library.
When connecting to the server with a pre-4.1 client program, use an aclearcase/" target="_blank" >ccount that still has a pre-4.1-style password.
Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Alternatively, use UPDATE and FLUSH PRIVILEGES:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
Substitute the password you want to use for ``newpwd'' in the preceding examples. MySQL cannot tell you what the original password was, so you'll need to pick a new one.
Tell the server to use the older password hashing algorithm:
Start mysqld with the --old-passwords option.
Assign an old-format password to each account that has had its password updated to the longer 4.1 format. You can identify these accounts with the following query:
mysql> SELECT Host, User, Password FROM mysql.user
-> WHERE LENGTH(Password) > 16;
For each account record displayed by the query, use the Host and User values and assign a password using the OLD_PASSWORD() function and either SET PASSWORD or UPDATE, as described earlier.
For additional background on password hashing and authentication, see section 5.5.9 Password Hashing in MySQL 4.1.
分享到:
相关推荐
该组件为MYSQL为ADO.NET访问MYSQL数据库设计的.NET访问组件。 安装完成该组件后,引用命名空间MySql.Data.MySqlClient; 使用命令行编译时:csc /r:MySql.Data.dll test.cs 下载地址: ...
mysql mysql驱动 mysqlODBC驱动 下载,直接下载 高速下载,mysql其他资料
安装 mysql5.7时提示:This application requires Visual Studio 2013 Redistributable. Please install the Redistributable then run this installer again. 需要安装指定版本的Microsoft Visual C++ ...
MySQLODBC配置[收集].pdf
我今天打算在Windows server 2008 R2中安装MySQL,可是总是发现ODBC连接器安装错误,无论我采用MySQL的整体安装包,还是单独的ODBC连接器安装文件!! 最后上网搜索了很久,终于解决了这个问题! 操作系统:Windows ...
将mysql数据库转换为sql server的数据库,或者将sql server数据库转换为mysql的数据库,在nt环境下很多时候都会用到。使用mysql odbc后就比较好办,可以使用sql server的管理工具,也可以使用mysql的管理工具,更可以...
mysql8.0和5.3版本对应的odbc,适用于是windows,有需要的朋友前来下载,谢谢大家的支持!
vc6.0的一个小例子 通过ado连接mysql 含odbc工具 希望可以帮到你们
windows 中mysql驱动和vsc++安装包
MySQL ODBC驱动是为MySQL数据库推出的一款驱动,它可以解决MySQL安装ODBC失败的问题,使数据库更好的连接MySQL的服务器,包括将微软的Access,Excel和Borland的Delphi去连接数据库服务器
VS2012连接Mysql数据库驱动。解决低版本的添加数据源后在VS2012里找不到。
对于C++连接mysql,我不太喜欢多下载一个软件mysqlodbc,所以采用的是通过mysql自己的API函数进行连接: 1、使用API的方式连接,需要加载mysql的头文件和lib文件。 在VS2010的附加包含目录中添加\MySQL\MySQL ...
ubuntu 16 64位 mysql-connector-odbc-5.3.13
java连接mysql数据库的驱动,mysql驱动程序_mysql-connector-java-8.0.17.jar 和 mysql-connector-odbc-8.0.17-winx64
简单的MFC连接MYSQL数据库,简单的图书查询功能MFC连接MYSQL数据库,简单的图书查询功能
支持linux64位系统,连接MySQL ODBC驱动连接器。mysql-connector-odbc-5.3.7-linux-ubuntu16.10-x86-32bit.tar.gz。
利用mysqlodbc将officeaccessexcel文件导入数据库.pdf
mysqlodbc驱动,用windows64位系统和mysql建立连接的驱动