Use Database Browser Portable to connect to AWS RDS

Trying to connect to a RDS on amazon web services can be a little confusing at times. Especially with permissions, as you do not want to open up the entire world to have access to your database.

The best way I have found to access the database is through the following steps:

  • Setup a security group that gives SSH access to your database (SSH Port 22)
  • Assign that security group to your RDS
  • Use a program like Putty and create a SSH tunnel to your RDS
  • SSH tunnel to localhost
  • When you want to connect to your database, connect to your EC2 instance via Putty, and then you will be able to access your RDS via localhost as the Host

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *