最近在学习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