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");
}
});
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:
var connection = mysql.createConnection({
host: "localhost",
user: "seth40047",
password: "",
database: "c9"
});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.