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

一、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'@'localhost' IDENTIFIED WITH mysql_native_password B