working script

script.js

// import modules
var express = require('express');
var mysql = require('mysql');
var app = express();

// implement connectionPool
var connection = mysql.createPool({
	// properties ...
		connectionLimit: 90, // only 90 queries at a time
		host:'localhost',
		user:'root',
		password:'KTMEi',
		database:'mantis_live_dev'
});

app.get('/', function(req, res){
	// about mysql
	// connection.query("SELECT * FROM mantis_live_dev WHERE", function(error, rows, fields));
	connection.getConnection(function(error, tempCont){
		if(!!error){
			tempCont.release();
			console.log('Error');
		} else {
			console.log('Successfully connected.');
			var query1 = "SELECT * FROM mysampletable WHERE id>10";
			tempCont.query(query1, function(error, rows, fields){
				tempCont.release();
				// callback
				if(!!error){
					console.log('Error in the query');
				} else {
					console.log('Success!\n');
					console.log(rows);
					// res.send('Hello, ' + rows[0].Name);
					res.json(rows);
					// parse with your rows/ fields
				}
			});
		}
	})
});

app.listen(1337);