const mysql = require('mysql');
let db:{
        host: "localhost",
        user: "x",//,
        password: "x",//"",
        port: 8889,//,8889
        database:  "UsersT",//""
        socketPath: '/Applications/MAMP/tmp/mysql/mysql.sock'
    }

console.log('tryin connection');

var connection = mysql.createConnection({db});


connection.connect((err) => {
    // in case of error
    if(err){
        console.error('error connecting: ' + err.stack);
        console.log(err.code);
        console.log('err fatal : '+err.fatal);
    }else{

        console.log('connected as id ' + connection.threadId);
    }
});

error connecting: Error: connect ECONNREFUSED 127.0.0.1:3306
    at Object._errnoException (util.js:992:11)
    at _exceptionWithHostPort (util.js:1014:20)
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1186:14)
    --------------------
    at Protocol._enqueue (/Users/dmn/Desktop/ApiNoTest/node_modules/mysql/lib/protocol/Protocol.js:144:48)
    at Protocol.handshake (/Users/dmn/Desktop/ApiNoTest/node_modules/mysql/lib/protocol/Protocol.js:51:23)
    at Connection.connect (/Users/dmn/Desktop/ApiNoTest/node_modules/mysql/lib/Connection.js:118:18)
    at Object.<anonymous> (/Users/dmn/Desktop/ApiNoTest/db.js:13:12)
    at Module._compile (module.js:652:30)
    at Object.Module._extensions..js (module.js:663:10)
    at Module.load (module.js:565:32)
    at tryModuleLoad (module.js:505:12)
    at Function.Module._load (module.js:497:3)
    at Function.Module.runMain (module.js:693:10)
ECONNREFUSED
err fatal : true