时间戳

首页 > 解决方案 > Nodejs Sequeslize 错误：连接 ECONNREFUSED

mysql - Nodejs Sequeslize 错误：连接 ECONNREFUSED

问题描述

我是 sequelize、mysql 和 phpmyadmin 的新手。我正在尝试连接到我的远程数据库，但出现以下错误：

未捕获的异常：500 - 连接 ECONNREFUSED xx.xxx.xxx.xx:xxxx，堆栈：SequelizeConnectionRefusedError：连接 ECONNREFUSED xx.xxx.xxx.xx:xxxx

我在 Stackoverflow 上查看了这个链接和其他各种解决方案，但它没有解决我的问题。

数据库.ts

import { Sequelize } from "sequelize";
import { DB_HOST, DB_NAME, DB_PASSWORD, DB_USER } from "../config";
export const DB = new Sequelize(DB_NAME, DB_USER, DB_PASSWORD, {
  host: DB_HOST,
  dialect: "mysql",
  logging: false,
  typeValidation: true,
  dialectOptions: {
    supportBigNumbers: true,
    bigNumberStrings: true,
  },
  define: {
    charset: "utf8mb4",
    collate: "utf8mb4_unicode_ci",
    createdAt: "created_at",
    updatedAt: "updated_at",
    deletedAt: "deleted_at",
    paranoid: true,
    underscored: true,
  },
  pool: {
    max: 5,
    min: 0,
    acquire: 30000,
    idle: 10000,
  },
});

标签： mysqlnode.jsexpressphpmyadminsequelize.js

解决方案

推荐阅读