i have created mysql connection in nodejs it is showing database connected but showing an error as undefined database

Question

var mysql = require('mysql');

var connection = mysql.createConnection({

host : 'localhost',
user : 'root',
port : '3306',
password : 'root',
database : 'test'

});

connection.connect(function(err){

if(!err) {

    console.log("database is connected"+database);
} else {
    console.log("database is not connected"+err.message);
}

});

this is the error i got

It seems like database is not declared, are you sure this variable exists ? — Sparw
the variable database in console.log("database is connected"+database); is undefined, you don't have such a variable in the scope, but seems that connection is successful — codtex

NItin Vaja NItin Vaja · Accepted Answer · 2017-12-07T08:57:32

Change your connect function to look like this: (Replacing function with fat arrow function "=>")

connection.connect((err) => {
    if (!err) {
        console.log("database is connected"+database);
    } else {
        console.log("database is not connected"+err.message);
    }
});

This below link explains why:

What is the difference between () => {} and function() {} in react-native javascript?

i have created mysql connection in nodejs it is showing database connected but showing an error as undefined database

1 Answers