error : connect ECONNREFUSED

Question

I am running a node app with mysql as my database(also using sequelize as ORM). Whenever I run the "app.js" file with "node" command, I get an error:

{ [Error: connect ECONNREFUSED 127.0.0.1:3306] code: 'ECONNREFUSED', errno: 'ECONNREFUSED', syscall: 'connect', address: '127.0.0.1', port: 3306, fatal: true }

my code in the app.js file:

var  mysql = require("mysql");

var connection = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "password",
  database: "openshare"
});

connection.connect(function(err){
  if(err){
    console.log(err);
  } else {
    console.log("no errors");
  }
});

Nothing was listening at 127.0.0.1:3306. MySQL wasn't running there, or running on a different port. — user207421, Apr 29 '17 at 01:56
Thanks that fixes it, but after that I get another error with the same code running: { [Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost' (using password: YES)] code: 'ER_ACCESS_DENIED_ERROR', errno: 1045, sqlState: '28000', fatal: true } — Seth Harlaar, Apr 29 '17 at 02:44
So you used an invalid username or password, or that user didn't have 'localhost ' access. — user207421, Apr 29 '17 at 02:52
@Adiii Not in my experience. Every time I've installed it I've been asked to *specify* a root password. — user207421, Apr 29 '17 at 06:14
https://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html — Adiii, Apr 29 '17 at 07:45
Thanks for help guys, your comments lead me towards the answer. — Seth Harlaar, Apr 29 '17 at 23:44

score 0 · Accepted Answer · answered Apr 29 '17 at 23:49

I probably should have mentioned before hand, but I am using cloud9 to for my node environment. Cloud9 has some things setup for you already:

Your "host" to connect to will just be "localhost".
"user" will be your cloud9 username.
"password will be left blank.
"database" will be "c9"

 var connection = mysql.createConnection({
  host: "localhost",
  user: "seth40047",
  password: "",
  database: "c9"
});

https://community.c9.io/t/setting-up-mysql/1718 This article is very helpful for anyone who is also having troubles setting up MySql on a cloud9 node environment.

Bobbi Lusic · Answer 2 · 2019-03-27T18:09:03.140

0

I had the same issue trying to connect node to a database in Cloud9. he fix was to

run the database and node in the same Cloud9 workspace.

Though this might be obvious to more experienced coders, I wrongly thought that I had the two workspaces communicating.

edited Mar 27 '19 at 18:09

answered Mar 27 '19 at 17:53

Bobbi Lusic

21
6

error : connect ECONNREFUSED

2 Answers2