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