时间戳

首页 > 解决方案 > 在 heroku "connect ECONNREFUSED 127.0.0.1:3306" 上部署我的 api 后出现此错误

mysql - 在 heroku "connect ECONNREFUSED 127.0.0.1:3306" 上部署我的 api 后出现此错误

问题描述

const Sequelize = require('sequelize');

const sequelize = new Sequelize(`${process.env.SQL_DB}`, 'root', `${process.env.SQL_Password}`, {
    dialect: 'mysql',
    host: 'localhost'
});

module.exports = sequelize;

虽然我将我的配置变量存储在 heroku 设置中，但我认为它无法连接到我的数据库

错误

Unhandled rejection SequelizeConnectionRefusedError: connect ECONNREFUSED 127.0.0.1:3306
2020-01-07T10:27:38.586244+00:00 app[web.1]:     at /app/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:139:19
2020-01-07T10:27:38.586246+00:00 app[web.1]:     at tryCatcher (/app/node_modules/bluebird/js/release/util.js:16:23)
2020-01-07T10:27:38.586248+00:00 app[web.1]:     at Promise._settlePromiseFromHandler (/app/node_modules/bluebird/js/release/promise.js:547:31)
2020-01-07T10:27:38.586250+00:00 app[web.1]:     at Promise._settlePromise (/app/node_modules/bluebird/js/release/promise.js:604:18)
2020-01-07T10:27:38.586252+00:00 app[web.1]:     at Promise._settlePromise0 (/app/node_modules/bluebird/js/release/promise.js:649:10)
2020-01-07T10:27:38.586254+00:00 app[web.1]:     at Promise._settlePromises (/app/node_modules/bluebird/js/release/promise.js:725:18)
2020-01-07T10:27:38.586256+00:00 app[web.1]:     at _drainQueueStep (/app/node_modules/bluebird/js/release/async.js:93:12)
2020-01-07T10:27:38.586258+00:00 app[web.1]:     at _drainQueue (/app/node_modules/bluebird/js/release/async.js:86:9)
2020-01-07T10:27:38.586260+00:00 app[web.1]:     at Async._drainQueues (/app/node_modules/bluebird/js/release/async.js:102:5)
2020-01-07T10:27:38.586262+00:00 app[web.1]:     at Immediate.Async.drainQueues [as _onImmediate] (/app/node_modules/bluebird/js/release/async.js:15:14)
2020-01-07T10:27:38.586264+00:00 app[web.1]:     at processImmediate (internal/timers.js:439:21)

标签： mysqlnode.jsherokusequelize.js

解决方案

推荐阅读