CODEWITHSUNDEEP
mysqlnode.js
ahmetbcakici
ahmetbcakici

Reputation: 423

NodeJS Error connect ECONNREFUSED about mysql database

I'm trying to connect my mysql database but i can not i got error that : Error: connect ECONNREFUSED 127.0.0.1:8889

My code : 

var express = require("express");
var app = express();

var mysql = require("mysql");
var bodyParser = require("body-parser");

app.use(bodyParser.json({type:'application/json'}));
app.use(bodyParser.urlencoded({extended:true}));

var con = mysql.createConnection({
    host:"localhost",
    port:"8889",
    user:"root",
    password:"root",
    database:"turktakvim_mobil"
});

var server = app.listen(8000,function(){console.log("localhost successfull");
    var host = server.address().address
    var port = server.address().port
});

con.connect(function(error){
    if(error) console.log("error : "+error);
    else console.log("database successfull");
});

and i got this output :
localhost successfull
error : Error: connect ECONNREFUSED 127.0.0.1:8889

I also checked my MAMMP settings , everything is okay

a screenshoot from my work

mammp settings

Upvotes: 0

Views: 3445

Answers (1)

user5943862
user5943862

Reputation: 39

I execute your code like:: it worked I think issue is with you mysql connection

var con = mysql.createConnection({
host:"localhost",
port:"3306",
user:"root",
password:"root",
database:"test"
});

execution

Upvotes: 1

Related Questions