sqlyog链接mysql数据库失败时,显示plugin caching_sha2_password could not be loaded

时间:2024-06-02 08:30:17

sqlyog链接mysql数据库失败时,显示plugin caching_sha2_password could not be loaded,步骤清晰,小白也能看懂!
sqlyog链接mysql数据库失败时,显示plugin caching_sha2_password could not be loaded
1、使用WIN+R打开cmd:进入mysql,即mysql的bin目录下,输入mysql -hlocalhost -uroot -p123456;
123456为自己设置的mysql登录密码。
2、进入mysql后,依次输入以下四条命令

①、ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER; #修改加密规则

②、ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’; #更新用户的密码

③、FLUSH PRIVILEGES; #刷新权限

④、ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘12345678’; #重置密码,更改自己想设置的密码,如12345678就是变更后的密码

看不懂看图片操作sqlyog链接mysql数据库失败时,显示plugin caching_sha2_password could not be loaded
完成以后重新链接sqlyog和mysql就可以连接成功了!sqlyog链接mysql数据库失败时,显示plugin caching_sha2_password could not be loaded