node连接mysql出现ER_NOT_SUPPORTED_AUTH_MODE问题

206 阅读1分钟

问题

由于node不支持最新mysql的密码加密方式,需要再mysql installer里修改配置设置为legacy authentication method node后端错误码如下

  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

解决

image.png 进入后

image.png 设置为旧版模式即可

image.png