解决Navicat连接mysql时提示【caching_sha2_password】问题

一、背景

用Navicat构建Mysql数据库后连接遇到以下问题
登录提示caching_sha2_passWord问题解决方法

二、解决方案

按window【开始】键，输入cmd 进入cmd窗口并输入，然后输入密码登录进入数据库中

mysql -u root -p

查看身份验证类型

mysql> use mysql;Database changedmysql> SELECT Host, User, plugin from user;±----------±-----------------±----------------------+| Host | User | plugin |±----------±-----------------±----------------------+| % | root | caching_sha2_password || localhost | mysql.infoschema | caching_sha2_password || localhost | mysql.session | caching_sha2_password || localhost | mysql.sys | caching_sha2_password || localhost | root | caching_sha2_password |±----------±-----------------±----------------------+5 rows in set (0.00 sec)

用户的验证器插件为 caching_sha2_password

修改身份验证类型(修改密码)

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';Query OK, 0 rows affected (0.00 sec)mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';Query OK, 0 rows affected (0.01 sec)

输入下面命令使修改生效

mysql> FLUSH PRIVILEGES;

使用Navicat验证是否生效

mysql> SELECT Host, User, plugin from user;±----------±-----------------±----------------------+| Host | User | plugin |±----------±-----------------±----------------------+| % | root | mysql_native_password || localhost | mysql.infoschema | caching_sha2_password || localhost | mysql.session | caching_sha2_password || localhost | mysql.sys | caching_sha2_password || localhost | root | mysql_native_password |±----------±-----------------±----------------------+5 rows in set (0.00 sec)

修改成功！

来源地址：https://blog.csdn.net/licongzhuo/article/details/129259945