9
10Dev
4y

Learning AWS, and it took me 2 hours to figure out that I can't connect to my database because I forgot to press the button to allow public access

I partially blame amazon, because a button that important shouldn't be so small and hidden, but I'm still an idiot

Comments
  • 1
    You added whitelist for Ips at least ? Not a fun of DB with public access
  • 0
    Please don't use public access. Said to aws to accept request only from your ip address
  • 0
    Enabling public access on a DB is dangerous, which is probably why the option is so small and hidden.
  • 1
    @jak645 @EmberQuill AWS public access means you can access the database without having to be in the databases VPC. My IP is still the only one whitelisted, but I can access the database without launching an EC2 instance in the VPC
  • 0
    @10Dev I’m happy to hear you’ve at least setup your IP as the only allowed address. That checkbox is a nuisance, especially when you don’t have other EC2 instances. Honestly, it’s why I recommend DigitalOcean in those cases. Yes, the best practice is to leave public access off... but with no other instances in AWS you don’t have any other *affordable* option.

    Once you start running EC2 instances, you’re better off not checking that box and just run an OpenVPN instance.
  • 1
    @AtuM 🙌 Yes! Require encryption in transit and at rest.
Add Comment