Connect EC2 in private subnet to RDS mysql in another private subnet


Hello!! I am looking for guidance on connecting EC2 to mysql (RDS) - both in separate private subnets but in the same VPC My current setup is:

  • 1 public subnet w/ ALB and a bastion server.
  • 1 private subnet w/ EC2 instance running my web app
  • 1 private subnet w/ RDS running mysql What configuration(s) do I need to have EC2 connect to mysql? Also, is there any way to use phpmyadmin to access mysql in a private subnet? Thank you in advance!
asked 10 months ago504 views
1 Answer

When setting up your private subnets. Ensure there is a local route for the cidr range for the subnets you wish to connect or for the whole VPC which is usual practice.

Your public subnets will have a different route than the private subnets because the default route will have a different path. Other than that the VPC cidr range route is set as local and they can all route to each other.

You can use the DNS endpoint name of your RDS for your EC2 to connect to your RDS.

You will need to allow in the inbound rule the SQL port on the RDS security group the EC2 security group or CIDR as the source.

Not sure what you mean use phpadmin. Are you referring to a SQL tool like workbench? Where will this be hosted?

profile picture
answered 10 months ago
profile picture
reviewed 2 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