'error : connect ECONNREFUSED

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");
  }
});
mysqlnode.jssequelize.jseconnrefused


Solution 1:[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.

Solution 2:[2]

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.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Seth Harlaar
Solution 2

Related Questions