navicat premium 12 客户端连接mysql8.0 提示 Authentication plugin 'caching_sha2_password' cannot be loaded 解决方法

1、user mysql

2、select user,host,plugin,authentication_string from user;

3、ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123'

4、ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123';

5、FLUSH PRIVILEGES;