robb33
2/4/2017 - 5:02 PM

connect mysql

connect mysql

var mysql = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : '',
  database : 'beer_db'
});
 
connection.connect();
 
connection.query('SELECT * from beers', function (error, results, fields) {
  if (error) throw error;
  console.log('The solution is: ', results);
});
 
connection.end();