{ Query error: connect ECONNREFUSED 127.0.0.1:3306
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1082:14)
--------------------
at Protocol._enqueue (/home/salim/Pulpit/helper/node_modules/mysql/lib/protocol/Protocol.js:144:48)
at Protocol.handshake (/home/salim/Pulpit/helper/node_modules/mysql/lib/protocol/Protocol.js:51:23)
at Connection.connect (/home/salim/Pulpit/helper/node_modules/mysql/lib/Connection.js:118:18)
at Connection._implyConnect (/home/salim/Pulpit/helper/node_modules/mysql/lib/Connection.js:453:10)
at Connection.query (/home/salim/Pulpit/helper/node_modules/mysql/lib/Connection.js:198:8)
at /home/salim/Pulpit/helper/server.js:28:5
at Layer.handle [as handle_request] (/home/salim/Pulpit/helper/node_modules/express/lib/router/layer.js:95:5)
at next (/home/salim/Pulpit/helper/node_modules/express/lib/router/route.js:137:13)
at Route.dispatch (/home/salim/Pulpit/helper/node_modules/express/lib/router/route.js:112:3)
at Layer.handle [as handle_request] (/home/salim/Pulpit/helper/node_modules/express/lib/router/layer.js:95:5)
  errno: 'ECONNREFUSED',
  code: 'ECONNREFUSED',
  syscall: 'connect',
  address: '127.0.0.1',
  port: 3306,
  fatal: true }

var app = express();
var server = require('http').createServer(app);
var io = require('socket.io').listen(server);
var mysql = require('mysql');

var serverPort = 3030;
var databasePort = 3031;
var dataBaseName = 'BazaDanych'

const db = mysql.createConnection({
    host: 'localhost',
    user: 'salimazeri',
    password: '123',
});

app.use(express.static(__dirname));

connections = [];

//------------------------------------------------------------------------------------------------------------

server.listen(process.env.PORT || serverPort);
console.log("server is running on port: " + serverPort);

app.get('/createdb', function(req, res){
    let sql = 'CREATE DATABASE ${BazaDanych}';
    db.query(sql, (err,result) =>{
        if(err){
            console.log('Query error: 'err);
        }
        console.log(result);
        res.send('Baza Danych utworzona...');
    })
});