title: Connect to AWS MySQL database via Node JS
body: <p>I have an instance on AWS and MySQL database working on it. 
  I was able to connect to the instance via workbench on my local machine. 
  However, I am not able to connect to the database via the node js code. 
  Below is the snippet : </p>
  
  <pre><code>var express    = require("express");
  var mysql      = require('mysql');
  var connection = mysql.createConnection({
    host     : 'ec2-52-33-41-xxx.us-west-2.compute.amazonaws.com',
   port      :  3306,
    user     : 'ec2-user',
    password : 'root',
    database : 'FAMILY_GIVING_TREE'
  
  });
  var app = express();
  
  connection.connect(function(err){
  
  if(!err) {
      console.log("Database is connected ... ");    
  } else {
      console.log("Error connecting database ... ");    
  }
  });
  </code></pre>
  
  <p>THE ERROR is : </p>
  
  <pre><code>{ [Error: connect ECONNREFUSED 52.33.xx.84:3306]
    code: 'ECONNREFUSED',
    errno: 'ECONNREFUSED',
    syscall: 'connect',
    address: '52.33.41.84',
    port: 3306,
    fatal: true }
  </code></pre>
  
  <p>The node js code is w=not written over the AWS instance, I am writing it on my machine and yes the port 3306 is enabled in security groups.</p>
  
  <p>I get the database connection issue. 
  Any idea where am I going wrong?
  Thanks in advance.</p>