nodejs mysql模块连接报错sqlMessage: “Client does not support authentication protocol requested by server； consider upgrading解决办法

报错场景：

报错信息：

{
  code: 'ER_NOT_SUPPORTED_AUTH_MODE',
  errno: 1251,
  sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
  sqlState: '08004',
  fatal: true
}

报错原因：

客户端不支持认证协议，考虑升级mysql客户端？

原因是mysql版本太新了，MySQL8.0和MySQL5.0的加密方式不一样，连接会报错。

解决办法：

1. cmd方式登录数据库
2. 更改mysql加密方式

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

3. 更新密码

mysql>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';

4. 刷新

mysql> FLUSH PRIVILEGES;