MySQL8.0 Unable to load authentication plugin 'caching_sha2_password'

第三方可视化工具连接MySQL8.0 Unable to load authentication plugin 'caching_sha2_password'

操作

• mysql -root -p 进入mysql数据库
• use mysql 将数据库切换到mysql
• alter user 'root'@'localhost' identified by '123456' password expire never; （单引号）
• alter user 'root'@'localhost' identified with mysql_native_password by '123456';
• flush privileges;

参考文章