How to setup your database at AWS to work with Heroku

(written by lawrence krubner, however indented passages are often quotes). You can contact lawrence at:

Spent some serious time trying to track down this answer. My company has a Sinatra app running via Heroku. I just started working at a new office that has never had access to these apps. How do I whitelist my IP address so I can reach the AWS server and run a command like mysqldump? Can I do that via the Heroku toolset? No. Apparently I need to log into the AWS console. These are useful resources:

Connecting Your Heroku App with Its Amazon MySQL Database

Heroku Amazon RDS