Navicate连接MySQL出现Authentication plugin ‘caching_sha2_password’ cannot be loaded的解决方法
问题描述:2059 - Authentication plugin ‘caching_sha2_password’ cannot be loaded:问题分析:MySQL8.0.19数据库的当前登录用户加密规则为caching_sha2_password,使用Navicat12.0连不上。修改加密规则解决问题:将用户的加密规则更改为mysql_native_passwordALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_nativ