Connecting NodeJS with MySQL

NodeJS+MySql

/* Sample code to connect MySQL DB in NodeJS
 * Table name: user
 * Test Result : Pass
 * Pre-requesties : NodeJS installed with Express, MySql dependencies.
 */
	 var express    = require("express")
	 var mysql      = require('mysql')
	 var app = express()
  	 app.listen(3306)
	   
	 app.get("/user", (req, res) => {
 
		 var connection = mysql.createConnection({
		   host     : 'localhost',
		   user     : 'root',
		   password : '',
		   database : 'mydb'
		 });
 
		connection.connect(function(err){
		 if(!err) {
			 console.log("Database is connected ... \n\n");  
		 } else {
			 console.log("Error connecting database ... \n\n");  
		 }
		 });

		connection.query("select * from user", (err, rows, fields) => {
			console.log("Users loaded")
			res.json(rows)
		})
	 });