Question

【iDesktop】【10.2.1】连接MySQL8失败，navicat能连接。报错信息：Plugin caching_sha2_password could not be loaded

Answer 1

【问题原因】MySQL8默认身份验证插件为caching_sha2_password 【解决办法】修改为mysql_native_password方式，有两种方法：1.修改加密方式：update user set plugin='mysql_native_password'; 2.修改密码：ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY '111111';