const express = require('express'),
    router = express.Router(),
    mysql = require('mysql');

var connection = mysql.createConnection({
    host: <ipaddress>,
    port: <default Port>,
    user: 'root',
    password: <given password>,
    database: <db name>,
    connectionTimeout: 30000
});

connection.connect((error) => {
    if (error) {
        console.log('error connecting: ' + error);
    } else {
        console.log('Connected to server');
    }
});

connection.query('SELECT * FROM test', function(err, results, fields) {

    console.log('results in table: ' + results);
    console.log('fields in table: ' + fields); // -1

    connection.release();

    if (err) throw error;
});
connection.end();

module.exports = router;