Mysql4安装Client does not support authentication protocol requested问题的解决
今天升级了一下Mysql数据库,结果出现了以下错误:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
升级到4.1.7版:
[root@eygle gbook]# mysql -uroot -p -heygle
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 44 to server version: 4.1.7-max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
查询了一下,在官方网站发现了解决方法:
http://dev.mysql.com/doc/mysql/en/Old_client.html
共有以下两种解决方法:
一:
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
二:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
使用第二种方法,解决了该问题。
分享到:
相关推荐
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 ...
mysql4.1以上版本连接时出现Client does not support authentication protocol问题解决办法 shell> mysql Client does not support authentication protocol requested by server; consider ...
主要给大家介绍了关于MySQL连接抛出Authentication Failed错误的分析与解决方法,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面随着小编来一起学习学习吧
1251 – Client does not support authentication protocol requested by server; consider upgrading MySQL client 二、原因 MySQL 8.0 改变了密码认证方式。 在 MySQL 8.0 之前版本的密码认证方式为: mysql_...
文件拷贝工具,绿色版,FastCopy,很好用的工具,文件拷贝工具,绿色版,FastCopy,很好用的工具,
解决Navicat for MySQL 连接 Mysql 8.0.4 出现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 原因在于MySQL8.0换了加密插件,而数据库管理客户端还是原来旧版本的加密方式,主要在于安装MySQL8.0过程...
问题1:Client does not support authentication protocol requested by Server;… 问题2:Unknown initial character set index ‘255′ received from server… 问题3:MySQL8.0连接必要url语句 问题4:调用方法...
Typescript-koa-微服务 使用TypeScript和Koa.js的示例微服务架构。 基于《清洁架构》一书。 包括以下内容: 数据库连接 ...{ Error: Client does not support authentication protocol requested by
如果使用 Navicat连接MySQL Server8.0版本时出现Client does not support authentication protocol requested by server; 解决办法: mysql> use mysql; mysql> alter user 'root'@'localhost' identified with ...