var mysql = require('mysql'),
        async = require('async');

var host = "whosting-mariadb-10-1-19-c1.c3uahxgwxkrq.us-east-1.rds.amazonaws.com";
var database = "56686_aniversariocorona";
var user = "whostingmaster";
var password = "d5291XeU76*V";

var dbclient;

async.waterfall([

    // 1. create database connection
    function (cb) {
        console.log("\n** 1. create connection.");
        dbclient = mysql.createConnection({
            host: host,
            user: user,
            password: password,
            database: database,
        });

        dbclient.connect(cb);
    },

    // 2. let's add a couple of albums. we will run them as separate
    //    queries.
    function (results, cb) {
        var query = "SELECT * FROM wp_users"
        dbclient.query(query,
                cb);
    }
],
// waterfall cleanup function
        function (err, results) {
            if (err) {
                console.log("Aw, there was an error: ");
                console.log(err);
            } else {
                console.log("All operations completed without error.");
            }

            dbclient.end();
        });