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 发布

阅读量212

点赞数

分类专栏： SQL

本文链接：https://blog.csdn.net/tianxian730/article/details/89082745

版权

SQL 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

客户端连接MySQL出现如下异常：

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

解决方法如下：

USE mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Root@2019';
FLUSH PRIVILEGES;

说明：

root是用户名，localhost是ip地址127.0.0.1都是特指本机，mysql_native_password是旧的密码验证机制，Root@2019是密码，最后别忘了分号

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

亦心天闲

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录

MySQL解决 1251 - Client does not support authentication protocol requested by server问题

qq_42680327的博客

04-13

587

问题：今天在电脑上给同事安装了MySQL8.0.11，然后去安装图形化Navicat for MySQL，打开Navicat准备链接数据库的时候出现了，如图所示：资料中出现这种情况的原因是： mysql8 之前的版本中加密规则是mysql_native_password，而在mysql8之后，加密规则是caching_sha2_password 解决方法：把mysql用户...

全网详细解决Client does not support authentication protocol requested by server；consider upgrading Mysql c

念兮为美

03-06

4167

全网详细解决1251 - Client does not support authentication protocol requested by server; consider upgrading Mysql client。

参与评论您还未登录，请先登录后发表或查看评论

navicat 连接不上虚拟机上的mysql容器 client does not support authentication protocol requested by server； consid

最新发布

gaoqiandr的博客

08-04

697

本文主要介绍的是如何解决远程连接MySQL出现的报错

Client does not support authentication protocol requested by server

didou8933的博客

05-07

121

关于由于版本号码不同而引起的 Client does not support authentication protocol requested by server 问题搜索类似的问题，得到的答案类似于下面 mysql>SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('newpassword'); 但是这些方法试了之后都是...

mysql 连接错误：client does not support authentication protocol requested by server； consid

qq_40890601的博客

10-13

1383

解决：把用户密码登录的加密规则还原成mysql_native_password这种加密方式首先来到mysql 安装的bin 目录下输入mysql -u root -p 来到mysql 的命令行然后分别执行 ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER; ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY

mysql - 报错1251- Client does not support authentication protocol requested by server；consider upgradi

高级前端工程师

05-08

3488

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，详细解决教程，连不上数据库

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

2375

解决方案：①升级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

报错：Client does not support authentication protocol requested by server； consider upgrading MySQL cli

m0_45382009的博客

08-09

2万+

修改mysql加密规则

Client does not support authentication protocol requested by server; conside

6块腹肌的博客

03-15

1万+

在node连接mysql时发生这样的错误，可以执行一下命令在终端先进入mysql，然后执行以下命令命令如下： 1、use mysql; 2、alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘数据库密码’; 3、flush privileges; ...

Client does not support authentication protocol requested by server；

Alex

02-16

424

　　　　Navicat连接MySQL Server8.0版本时出现Client does not support authentication protocol requested by server；解决如下：命令如下： 1、use mysql; 2、alter user 'root'@'localhost' identified with mysql_na...

Client does not support authentication protocol requested by server.......

xiasohuai的博客

05-27

219

上篇刚写了安装Mysql，想用Navicat去连接，然后就报错了，此处记录报错解决。报错：Client does not support authentication protocol requested by server; consider upgrading MySQL client 第一步在命令行输入 mysql -uroot -p 第二步 mysql> alter user...

问题：Client does not support authentication protocol requested by server；consider upgrading MySQL Clie

m0_46576135的博客

04-01

1160

问题：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.

Client does not support authentication protocol requested by server；consider upgrading MySQL clie

Snowpie的博客

03-04

3038

网络解决办法1：（博主尝试了该方法但是无用）在mysql命令行里输入下面两个命令：#这里的root就是账号，123456修改后的密码，根据自己的需求更改#刷新权限。