MYSQL RDS on EC2 instance


Why would I be able to connect to mysql rds database locally but not on my ec2 environment?

1 Answer

Assuming that EC2 and RDS are in the same VPC, check the security group associated with the RDS instance has an inbound rule allowing TCP port 3306 from the EC2's IP address, and that the security group associated with the EC2 allows TCP port 3306 outbound to the RDS instance.

If they're in different VPCs then check the VPC peering setup, and the route tables for both subnets.

profile picture
answered 3 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions