mysql-2059 – 身份验证插件’caching_sha2_password’-navicat连接异常

刚安装上本地Navicat 结果告知我

所以我就去搜楼了一下，碰到了

show variables like 'default_authentication_plugin';

 select host,user,plugin from mysql.user;

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

select host,user,plugin from mysql.user;

就可以啦~~~~~~