mysql8.0出现的2059 - authentication plugin 'caching_sha2_password' -navicat连接异常问题解决
1.找到配置文件my.ini
将default_authentication_plugin=caching_sha2_password改为default_authentication_plugin=mysql_native_password
2.用命令行登陆
mysql -u root -p
123456
3.use mysql
4.ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
5.flush privileges;
6.可以用navicat登陆了
更改后，user密码为root
标签：Premium,plugin,MySQL,Navicat,authentication,mysql,password,root From： https://www.cnblogs.com/SmokedInk/p/17318676.html