client does not support authentication protocol requested by server;consider upgrading mysql client

最新推荐文章于 2024-08-04 09:58:47 发布
最新推荐文章于 2024-08-04 09:58:47 发布
阅读量218 收藏
点赞数 1
文章标签： mysql Navicat Premium
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_42869574/article/details/85240303
版权

Mysql8.0使用低版本Navicat Premium报这个错，应为加密方式不一样了，我们需要需改加密的方式

到mysql的bin文件下Shift + 鼠标右键选择运行程序窗口 输入命令
mysql -u root -p

mysql>ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘你的密码’;
mysql>FLUSH PRIVILEGES;
mysql>quit

就可以了在连接Navicat Premium

析木之林
关注
全网详细解决Client does not support authentication protocol requested by server；consider upgrading Mysql c
念兮为美
03-06 4010
全网详细解决1251 - Client does not support authentication protocol requested by server; consider upgrading Mysql client。
mysql - 报错1251- Client does not support authentication protocol requested by server；consider upgradi
高级前端工程师
05-08 3191
mysql，navicat，数据库，MySQL数据库无法连接，如何连接本地数据库，Navicat软件提示报错，Navicat mysql无法连接本地的数据库怎么办，连接数据库弹框提示，navicat连接mysql提示报错，1251错误代码，navicat 1251解决方案，1251- Client does not support authentication protocol requested by server;consider upgrading Mysql client，详细解决教程，连不上数据库
Mysql 解决1251- Client does not support authentication protocol requested by server...的问题
专注自动化、性能测试、测试架构学习交流
06-13 7万+
一、问题描述 使用Navicat客户端连接本地mysql，报错：1251- Client does not support authentication protocol requested by server;consider upgrading Mysql client 二、查看用户信息 打开命令行小黑屏，进入MySQL的bin目录，然后输入mysql -u root -p，输入密码，登录成功 执行SQL查询用户信息 select host,user,plugin,authen.
navicat 连接不上虚拟机上的mysql容器 client does not support authentication protocol requested by server； consid
热门推荐
yubin1285570923的博客
10-24 7万+
一、问题产生 在centOS 通过docker pull mysql下载mysql镜像并成功启动mysql容器。 当通过windows主机navicat连接虚拟的mysql时报如下错误。Client does not support authentication protocol requestedbyserver; consider upgrading MySQLclient ...
client does not support authentication protocol requested by server；consider upgrading Mysql client
最新发布
gaoqiandr的博客
08-04 391
本文主要介绍的是如何解决远程连接MySQL出现的报错
错误(Client does not support authentication protocol requested by server; consider upgrading MySQL cli...
weixin_34163741的博客
06-12 94
官方的说法是         MySQL   4.1   and   up   uses   an   authentication   protocol   based   on   a   password   hashing   algorithm   that   is   incompatible   with   that   used   by   older   clients. ...
Client does not support authentication protocol requested by server; consider upgrading MySQL client
博客&brz
01-09 658
今天使用MySQL往数据库插入数据时IDEA报错：Client does not support authentication protocol requested by server; consider upgrading MySQL client. 解决方法： use mysql; alter user 'root'@'localhost' identified with mysql_n...
MYSQL 错误：Client does not support authentication protocol requested by server;
Mervyn(vivo)的专栏
04-07 1916
MYSQL 错误： Client does not support authentication protocol requested by server; MYSQL 帮助：A.2.3 Client does not support authentication protocolMySQL 4.1 and up uses an authentication protocol based on
client does not support authentication protocol requested by server consider upgrading MySQL Client
10-20
这个错误通常是由于 MySQL 服务器使用了比... ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; ``` 其中，'username' 和 'password' 分别是您要更改的用户名和密码。
Client does not support authentication protocol requested by server； consider upgrading MySQL client
m0_71467037的博客
06-03 2339
解决方案：①升级navicat，使其跟mysql8版本规则一致（这里不做讲解）②把用户密码登录的加密规则还原成mysql_native_password方法②步骤如下：1、进入数据库 mysql -uroot -p 2、使用mysql数据库： use mysql;3、查询user为root的host select user,host,plugin from user where user='root'; 4、执行永不过期策略 ALTER USER 'r
navicat: Client does not support authentication protocol requested by server；
混世小妲己
06-06 2万+
参考：https://www.cnblogs.com/zichuan/p/9203129.html 本人用的方法一解决的 问题: Navicat连接MySQL Server8.0版本时出现Client does not support authentication protocol requested by server； 原因： 当前的身份验证协议实现使用密码散列算法，该算法与较旧（4....
Client does not support authentication protocol requested by server
11-28 216
 今天遇到一个问题在zend studio 上客户端遇到Client does not support authenticationprotocol requested by server如果你升级mysql到4.1以上版本后遇到以上问题,请先确定你的mysql client 是4.1或者更高版本.解决方案mysql -u xxx -pmysql>UPDATE mysql.us
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值