将完成的项目迁移到 Docker

问：

我创建了一个应用程序，一个Node.js服务器和一个MySQL数据库。

最初，对于此应用程序，通过端口 3306 安装与数据库的连接，服务器从 3000 启动。

我为 Docker 创建了 2 个容器，一个用于数据库，另一个用于服务器。

我分配了端口 3307 和 3001 来侦听两者。但是我在连接到端口 3307 时出错。对于实验，我将其设置为 3306，但很明显这里存在错误，因为端口已被初始连接占用。

我在 Connection 中查看了停止端口 3306 的不同答案，这会影响应用程序的运行，Docker 容器将如何替换它？我应该怎么做？

我通过MySQL Workbench使用数据库

Docker文件：

ARG NODE_VERSION=18.14.0
ARG DB_HOST=mysql-container
ARG DB_PORT=3306
ARG DB_USER=root
ARG DB_PASSWORD=...
ARG DB_NAME=...


FROM node:${NODE_VERSION}-alpine

ENV DB_HOST=$DB_HOST
ENV DB_PORT=$DB_PORT
ENV DB_USER=$DB_USER
ENV DB_PASSWORD=$DB_PASSWORD
ENV DB_NAME=$DB_NAME

ENV NODE_ENV production


WORKDIR /...
RUN --mount=type=bind,source=package.json,target=package.json \
    --mount=type=bind,source=package-lock.json,target=package-lock.json \
    --mount=type=cache,target=/root/.npm \
    npm ci --omit=dev

USER node

COPY ...

EXPOSE 3000

CMD npm start

compose.yaml：

version: '3'
services:
  server-container:
    build:
      context: .
      dockerfile: Dockerfile
    ports:
      - "3001:3001"
    depends_on:
      - mysql-container

  mysql-container:
    image: mysql:latest
    environment:
      MYSQL_ROOT_PASSWORD: pass
      MYSQL_DATABASE: DBName
      MYSQL_ALLOW_EMPTY_PASSWORD: "no"
    ports:
      - "3307:3306"

错误

backend-server-container-1  |
backend-server-container-1  | > [email protected] start
backend-server-container-1  | > node server.js
backend-server-container-1  |
backend-server-container-1  | Server started 3000
backend-server-container-1  | node:events:491
backend-server-container-1  |       throw er; // Unhandled 'error' event
backend-server-container-1  |       ^
backend-server-container-1  |
backend-server-container-1  | Error: connect ECONNREFUSED 127.0.0.1:3307
backend-server-container-1  |     at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16)
backend-server-container-1  | Emitted 'error' event on Connection instance at:
backend-server-container-1  |     at Connection._notifyError (/backend/node_modules/mysql2/lib/connection.js:252:12)
backend-server-container-1  |     at Connection._handleFatalError (/backend/node_modules/mysql2/lib/connection.js:183:10)
backend-server-container-1  |     at Connection._handleNetworkError (/backend/node_modules/mysql2/lib/connection.js:196:10)
backend-server-container-1  |     at Socket.emit (node:events:513:28)
backend-server-container-1  |     at emitErrorNT (node:internal/streams/destroy:151:8)
backend-server-container-1  |     at emitErrorCloseNT (node:internal/streams/destroy:116:3)
backend-server-container-1  |     at process.processTicksAndRejections (node:internal/process/task_queues:82:21) {
backend-server-container-1  |   errno: -111,
backend-server-container-1  |   code: 'ECONNREFUSED',
backend-server-container-1  |   syscall: 'connect',
backend-server-container-1  |   address: '127.0.0.1',
backend-server-container-1  |   port: 3307,
backend-server-container-1  |   fatal: true
backend-server-container-1  | }
backend-server-container-1  |
backend-server-container-1  | Node.js v18.14.0
backend-server-container-1  | npm notice
backend-server-container-1  | npm notice New major version of npm available! 9.3.1 -> 10.2.3
backend-server-container-1  | npm notice Changelog: <https://github.com/npm/cli/releases/tag/v10.2.3>
backend-server-container-1  | npm notice Run `npm install -g [email protected]` to update!
backend-server-container-1  | npm notice
backend-server-container-1 exited with code 1

.env

DB_HOST=localhost
DB_USER=root
DB_PASSWORD=...
DB_NAME=...

DBConnection.js

const mysql = require("mysql2");

const db = mysql.createConnection({
  host: process.env.DB_HOST || "localhost",
  user: process.env.DB_USER || "root",
  password: process.env.DB_PASSWORD || pass, //same value like in .env
  database: process.env.DB_NAME || name, //same value like in .env
});

module.exports = db;

关于 3307 的任何提及