Connect to AWS MySQL database via Node JS

Question

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 :

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 ... ");    
}
});

THE ERROR is :

{ [Error: connect ECONNREFUSED 52.33.xx.84:3306]
  code: 'ECONNREFUSED',
  errno: 'ECONNREFUSED',
  syscall: 'connect',
  address: '52.33.41.84',
  port: 3306,
  fatal: true }

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.

I get the database connection issue. Any idea where am I going wrong? Thanks in advance.

Is the NodeJS code running on the same server as the database? If not you will need to open port 3306 in the Security Group. — Mark B
– Mark B, Commented Jul 10, 2016 at 3:46
Is there a way to avoid adding the mysql dependency.. does AWS-native not have a something like mysql-client that I could just require without adding the package (and allt he other things that would then require). You have to reduce your sizes as far as possible for APIs running serverless — Randhir Rawatlal
– Randhir Rawatlal, Commented Jun 3, 2020 at 12:05

Piyush Patil · Accepted Answer · 2016-07-10 10:26:18Z

4

There is a syntax error in your node.js code. Replace port : 3306, with below you are missing the ''

port : '3306',

answered Jul 10, 2016 at 10:26

Piyush Patil

14.6k8 gold badges45 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Medi · Accepted Answer · 2018-07-15 06:11:30Z

2

First, you must do the settings, that make Mysql accessible remotely.

https://mariolurig.com/coding/connect-remotely-mysql-database-amazon-ec2-server/

Second, in my case, I had to use my ec2 public IP address instead of public DNS. So:

var connection = mysql.createConnection({
  host     : '52.33.41.xx',
 port      :  '3306',
  user     : 'remote',
  password : 'password',
  database : 'FAMILY_GIVING_TREE'

});

Third, keep in mind that 'remote' is the user you grant all privilege on your DB for localhost and '%' (from all IP ). GoodLuck

answered Jul 15, 2018 at 6:11

Medi

635 bronze badges

Collectives™ on Stack Overflow

Connect to AWS MySQL database via Node JS

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related