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;

参考文章

转载于:https://www.cnblogs.com/QullLee/p/9433634.html