Can't reach mysql server with Node.js & AWS EC2

Question

I'm not using AWS RDS, only using AWS EC2.

I uploaded my data to the MySQL server on AWS EC2 Ubuntu 20.04 on port 3306.

Also, at that ubuntu, I am running my Node.js web server on port 3000.

But, the web server can't reach the MySQL server. They always say

err :  { Error: connect ECONNREFUSED 127.0.0.1:3306
    at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1107:14)

The above picture is my inbound rule now.

I checked my data is in MySQL server using some query...

Is there anything to do more?

If you need more information about my setting or something, please let me know.

You have both ms mql and nodejs running in same EC2 instance? — Balu Vyamajala
– Balu Vyamajala, Commented Mar 14, 2021 at 9:32
If your MySQL is on localhost with your app, then security groups are irrelevant. Can you use mysql cli to connect to your db? — Marcin
– Marcin, Commented Mar 14, 2021 at 9:59
Yes, I am both running mql and nodejs in the same EC2 instance. — mimic
– mimic, Commented Mar 14, 2021 at 19:57

Yuqiu G. · Accepted Answer · 2021-03-14 11:00:35Z

1

maybe the following steps can help you to resolve this:

make sure that it runs locally first on MySQL docker container: create database name, a user with sufficient rights in MySQL, connect to it applying username, password, URL, port, and other options.
document those steps and try the exact same steps on ec2, I see you already exposed the 3306 port, that is good. Btw. I would try with heroku with node first, because there is more documentation with Heroku CL and cleardb, which is the addon for MySQL and it is free :)
btw. normally a database should be placed in a private subnet and access should only be allowed via a nat-instance / nat-gateway, so that only requests from the public subnet are permitted, but the database can still download patches via nat, just to keep the best practice in mind ;)

edited Mar 14, 2021 at 11:00

answered Mar 14, 2021 at 9:49

Yuqiu G.

3584 silver badges8 bronze badges

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

1 Comment

Sriram BSETEC Oct 8 at 9:24

I'm not using AWS RDS, only using AWS EC2. I uploaded my data to the MySQL server on AWS EC2 Ubuntu 20.04 on port 3306. Also, at that ubuntu, I am running my Node.js web server on port 3000. But, the web server can't reach the MySQL server. They always say

Collectives™ on Stack Overflow

Can't reach mysql server with Node.js & AWS EC2

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related