0

I need to connect to an RDS from my home computer.

This is an established database, I'm migrating it to a new system.

I can not connect to it from my home computer.

I have set the security to Public Accessibility.

I've set VPC the Security rules to allows in bound connections.

What do I do next to debug it

RDS Screen enter image description here Security Groups enter image description here VPC enter image description here

I've included information on the Subnet is that relevant?

enter image description here enter image description here

Some Guy Trying To Do Math
  • 101
  • 1

1 Answers1

0

Great that you provided screenshots, makes it much easier to help :)

It looks to me like your database is in a private subnet, which means there is no route from the internet to your database. The way to fix it is on this AWS page, which in summary says "change your route table to make your private subnet a public subnet by adding a route from the internet to the subnet".

The "allow public access" doesn't magically provide access from the internet to your database. I didn't know what it did now as I have never needed to do that, but this page tells me it simply allocates the RDS instance a public IP. Without a public IP there's no way to connect direct from the internet, it's only accessible from the VPC IP range. After ticking it you still need to provide security groups, routes, etc.

Make sure your security group allows ingress only from your public IP, not from 0.0.0.0/0.

Tim
  • 31,888
  • 7
  • 52
  • 78