Node.js with MySql Database connection

Node.js with MySql.

Here I am putting simple example to show how to connect


  var mysql =  require('mysql');

  var connection =  mysql.createConnection({
      host : "localhost",
      user : "root",
      password: "vikash"
  });

connection.connect();


 connection.query("use cart");
  var strQuery = "select * from item";   
 
  connection.query( strQuery, function(err, rows){
      if(err)    {
          throw err;
      }else{
          console.log( rows );
      }
  });