mysql8.0安装即用navicat连接报错caching_sha2_password

mysql8.0安装参考https://blog.csdn.net/weixin_45822938/article/details/123383816
1.更改密码为root

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

2.更改加密方式

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER;

3.刷新：

FLUSH PRIVILEGES;