连接总是出现错误,故在此记录一下解决方法
方法来自:https://blog.csdn.net/XDMFC/article/details/80263215
错误:1251:Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决方法:mysql -u root -p
输入密码 进入root用户
mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123(此处是修改后的密码)’;
mysql> FLUSH PRIVILEGES;