报错提示:1251-Client does not support authentication protocol requested by server;
解决办法:
1》mysql -u root -p
2》更改加密方式:mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
这里如果localhost修改为通配符就需要使用通配符%,其中password是密码;
3》修改密码:mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
4》刷新:mysql> FLUSH PRIVILEGES;