1、运行cmd，目录定位到MySql的安装目录“C:\Program Files\MySQL\MySQL Server 8.0\bin”
2、运行mysql
3、运行如下的两个命令
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘password‘ PASSWORD EXPIRE NEVER; ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘password‘;
4、运行如下指令刷新密码，并更新密码
FLUSH PRIVILEGES; alter user ‘root‘@‘localhost‘ identified by ‘新密码‘;
5、再次连接就可以了
Navicat Premium 连接MySQL数据库出现Authentication plugin 'caching_sha2_password' cannot be loaded的解决方案
原文：https://www.cnblogs.com/feihusurfer/p/10939794.html