title: Node.js MySQL - Error: connect ECONNREFUSED
body: <p>I use Node.js server side. I tried my code on localhost and everything works fine. I bought a server and installed Apache and node.js on it and test my web application there. I correctly changed the MySQL connection configurations from localhost to the server configurations. </p>
  
  <p>I test my web application with this configuration:</p>
  
  <pre><code>var mysql      = require('mysql');
  var mysqlConnection;
  function new_mysqlConnection() {
      mysqlConnection = mysql.createConnection({
        host     : 'myurl.at',
        user     : 'myusername',
        database : 'mydatabase',
        password : 'mypassword'
      });
  }
  </code></pre>
  
  <p>I start the node.js server with: </p>
  
  <pre><code>$ node server.js
  </code></pre>
  
  <p>When I load the page, it's correctly displayed, but when Node.js try to connect to the database I always got the following error: </p>
  
  <pre><code>Error: connect ECONNREFUSED
      at errnoException (net.js:905:11)
      at Object.afterConnect [as oncomplete] (net.js:896:19)
      --------------------
      at Protocol._enqueue (/var/www/node_modules/mysql/lib/protocol/Protocol.js:135:48)
      at Protocol.handshake (/var/www/node_modules/mysql/lib/protocol/Protocol.js:52:41)
      at Connection.connect (/var/www/node_modules/mysql/lib/Connection.js:119:18)
      at reconnectDb (/var/www/server.js:319:18)
      at app.get.email (/var/www/server.js:109:2)
      at Layer.handle [as handle_request] (/var/www/node_modules/express/lib/router/layer.js:82:5)
      at trim_prefix (/var/www/node_modules/express/lib/router/index.js:302:13)
      at /var/www/node_modules/express/lib/router/index.js:270:7
      at Function.proto.process_params (/var/www/node_modules/express/lib/router/index.js:321:12)
      at next (/var/www/node_modules/express/lib/router/index.js:261:10)
  </code></pre>