quickly set up a connection to mysql db

sequlize.js

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


connection.connect(function (err) {
  if (err) {
    console.error('error connecting: ' + err.stack);
    return;
  }
  console.log('connected as id ' + connection.threadId);
});

const getAll = () => {
  return new Promise ((resolve, reject) => {
    connection.query('SELECT * from authors', (err, data) => {
      if (err) reject(err);
      else resolve(data);
    });
  });
};

getAll().then(data => console.log(data))