问题描述:
想要使用Navicat for MySQL连接mysql时出现错误,即无法加载插件缓存sha2密码。
部分参考他人博客进行处理(链接在最下面)
问题:输入ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
出现如下报错: ERROR: 1524: Plugin 'mysql_nativate_password' is not loaded
解决方案:![在这里插入图片描述](https://img-blog.csdnimg.cn/5867ec4e334d498b8f608be94d3f0610.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA6IW55pyJ6K-X5Lmm77yM5L2V5oKj5peg6L6e,size_12,color_FFFFFF,t_70,g_se,x_16)
按下图选择即可
参考:https://blog.csdn.net/qq_41538097/article/details/106905416