mysql4.1以上版本连接时出现Client does not support authentication protocol问题解决办法
shell> mysql
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
官方的说法是
MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. .....
如果你升级mysql到4.1以上版本后遇到以上问题,请先确定你的mysql client 是4.1或者更高版本.
请使用以下两种方法之一
其一:
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 ...
MYSQL出现" Client does not support authentication "的解决方法
1、拉取最新的mysql:docker pull mysql 2、配置端口映射以及密码启动mysql:docker run ‐p 3306:3306 ‐‐name mysql02 ‐e MYSQL_ROOT_PASSWORD=123456 ‐d mysql 3、进入docker中mysql控制台:docker exec -it ...
mysql4.1以上版本连接时出现Client does not support authentication protocol问题解决办法
1251- Client does not support authentication protocol …的错误,网上查了一下 ,某位前辈直接给出了答案,特此记录,以为成长道路上留下足迹… 原因: mysql 8.0之前的版本的加密规则与8.0不同,之前是mysql_...
主要给大家介绍了关于MySQL连接抛出Authentication Failed错误的分析与解决方法,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面随着小编来一起学习学习吧
1251 – Client does not support authentication protocol requested by server; consider upgrading MySQL client 二、原因 MySQL 8.0 改变了密码认证方式。 在 MySQL 8.0 之前版本的密码认证方式为: mysql_...
问题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:调用方法...
解决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过程...
文件拷贝工具,绿色版,FastCopy,很好用的工具,文件拷贝工具,绿色版,FastCopy,很好用的工具,
Typescript-koa-微服务 使用TypeScript和Koa.js的示例微服务架构。 基于《清洁架构》一书。 包括以下内容: 数据库连接 ...{ Error: Client does not support authentication protocol requested by
PHPMySQL复制 纯PHP实现MySQL复制协议。 这使您可以接收事件,例如插入,更新,删除及其数据和原始SQL查询。 基于伟大的创作者: : 和 安装 在你的项目中 composer require ... mysql 8.0(仅适用于mysql_native
如果使用 Navicat连接MySQL Server8.0版本时出现Client does not support authentication protocol requested by server; 解决办法: mysql> use mysql; mysql> alter user 'root'@'localhost' identified with ...
* SQL injection testing and detection does not depend upon the web application database management system back-end. SQL injection exploiting and query syntax obviously depend upon the web ...
Note that this directive does not control the , which can be ; used regardless of this directive. ; Default Value: On ; Development Value: Off ; Production Value: Off ; http://php.net/short-open-tag ...