将default_authentication_plugin=caching_sha2_password
改为default_authentication_plugin=mysql_native_password
用命令行登陆root用户
执行
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
注意!!!不是执行:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
再刷新
flush privileges;
再次navicat登陆 ok了;