mysqlConnection.js

var mysql = require('mysql')
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : 'Passphrase',
  database : 'mydatabase'
});

connection.connect()

connection.query('SELECT * from temp', function (err, rows, fields) {
  if (err) throw err

  console.log('The solution is: ', rows[2].name , ' ' ,  rows[2].index)
})

connection.end()