时间戳

首页 > 解决方案 > 错误：ER_NOT_SUPPORTED_AUTH_MODE 节点docker镜像和本地mysql连接错误

mysql - 错误：ER_NOT_SUPPORTED_AUTH_MODE 节点docker镜像和本地mysql连接错误

问题描述

我的节点 js docker server 无法连接我的 mysql

  #Database connection
  DB_HOST=192.168.3.201
  DB_PORT=3306
  DB_USER=myname
  DB_PASSWORD=******
  DB_DATABASE=my_db

这是我的环境文件

Connection fails: Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
user-service     | It will be retried for the next request.
user-service     | /usr/src/app/node_modules/mysql/lib/protocol/Parser.js:437
user-service     |       throw err; // Rethrow non-MySQL errors
user-service     |       ^
user-service     |
user-service     | Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

这是我得到的错误。当我尝试运行我的 docker-compose 文件时，会出现此错误。 npm start工作正常。

标签： mysqlnode.jsdocker

解决方案

推荐阅读