报错
2059-Authentication plugin'caching_sha2_password'cannot be loaded:Xxxx
解决(%代表所有网络可以链接,可以自己改成localhost本地链接):
1.登录mysql
mysql -u root -p
2.修改加密规则(123456是你的密码)
ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
3.修改用户密码(123456是root的密码)
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
4.重新链接即可成功