mysql 报错:Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support...

1,058 阅读1分钟

最近在学习vue+node+mysql+express制作后台页面,刚开始连接数据库遇到问题,错误提示:

Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support
authentication protocol requested by server; consider upgrading
MySQL client

解决问题:

1.打开终端,进入MySQL的bin目录,然后输入mysql -u root -p

sudo /usr/local/mysql/bin/mysql -u root -p

2.终端提示:输入密码

3.依次输入

 ALTER USER 'root'@'localhost' IDENTIFIED BY 'yourpassword' PASSWORD EXPIRE NEVER;

4.继续输入

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '12345678'; 

5.最后一步

FLUSH PRIVILEGES; #刷新权限

6.输入刚刚修改的密码,再次测试连接,搞定

如下提供终端截图:


友情提示: 如果输入过程中出现以下代码,请启动MySql.
ERROR 2002 (HY000): Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (2)

参考学习链接: https://www.jianshu.com/p/c8eb6d2471f8