MAC下mysql连接node报错 code: ‘ER_NOT_SUPPORTED_AUTH_MODE‘, errno: 1251, sqlMessage: ‘Client does not

十年尚可

于 2021-06-30 12:51:21 发布

阅读量2.4k

点赞数 6

分类专栏：前端学习

本文链接：https://blog.csdn.net/bianxia123456/article/details/118358652

版权

一、mysql版本

报错如下：

code: 'ER_NOT_SUPPORTED_AUTH_MODE',
errno: 1251,
sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',

解决办法：
先登录数据库：

mysql -u root -p

然后

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

然后

mysql>ALTER USER 'root'@

最低0.47元/天解锁文章