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