Navicat for MySQL连接mysql提示Client does not support authentication protocol requested by server; consider upgrading MySQL client
 客户端不支持服务器请求的身份验证协议;考虑升级MySQL客户端
 
解决方案：
 1、use mysql;
 2、alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘密码’;
 3、flush privileges;

MySQL忘记root密码如何登录
 
MySQL 8.0.19 - SQLyog客户端无法连接MySQL服务器
 
翻译之后是: 客户端不支持服务器请求的身份验证协议; 考虑升级MySQL客户端
 
解决方案:(以下红色引用和黑色代码块均为输入语句)
 
 
已知密码修改
 
  
可在cmd中登录mysql -u root -p
当root作为用户 localhost的您的网址，并password为您的密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
 
 
 
不知密码修改
 
  
管理员进入cmd , (未配置MySQL环境变量的进入bin路径下 ), 输入
mysqld --console --skip-grant-tables --shared-memory  //免密登录,不加载授权表
 
另外开一个cmd，使用mysql直接无密登录 mysql -u root
use mysql
 先刷新一下权限表 flush privileges
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
 
 
 
重新登录即可

错误：Client does not support authentication protocol requested by server; consider upgrading MySQL client
 
客户端不支持服务器请求的认证协议；考虑升级MySQL客户端
 
先登录：
 
mysql -u root -p
#接着输入你的密码
 
解决办法：
 
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';
SELECT plugin FROM mysql.user WHERE User = 'root';

今天用Navicat连接mysql不是3306的那种端口的数据库时提示Client does not support authentication protocol requested by server; consider upgrading MySQL client；
 
解决方案，升级就完事了，都提示你升级了还考虑什么 ？？ 用高版本的就能连上了