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");
  }
});

Answer 1

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:

1. Your "host" to connect to will just be "localhost".
2. "user" will be your cloud9 username.
3. "password will be left blank.
4. "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.