const mysql = require('mysql');
 
const testConnection = async( _host, _user, _password, _database) {
    return new Promise((resolve, reject) => {
        let status = false;
        let connection = mysql.createConnection({
            host     : _host,
            user     : _user,
            password : _password,
            database : _database
        });
    
        connection.connect((err) => {
            if(err) {
                reject(err)
            }
            else {
                resolve()
            }
        });
    })
}

// Connect to the database
(async() => {
    try {
        await testConnection()
        console.log('Connected!')
    }
    catch (err) {
        console.log('MySql could not connect:', err)
    }
})()