How to Connect to AWS RDS Database with MySQL Workbench

Connecting to aws rds database using mysql workbench.

[fgnxdfgsdzfhdfsahgd]

Dude, 8 years later and this still helped me after a whole day of trying to figure out AWS authetnication and how stuff connects to each other, it's such a pain in the ass at first. Also, it's comical to see how much the UI has changed, but the gist of it still works. THANK YOU!

Just a note for others, if you're on Posgres like me obviosly the port is different etc, but also if your EC2 is Ubuntu, Debian or some of the other distros, the username will not be ec2-user, just look it up for your case if it's not working. It'll usually be either admin, root or the distro name itself.

[vidilante]

I was about to give up for the day after reading 100 different 'tutorials', trying about 800 different combinations of inputs to MySQL Workbench and after watching this video I was able to connect immediately to my RDS MySQL instance. Thank you for letting me sleep tonight!

[jmonit]

Thanks A TON man I have been struggling with this for several days now, AWS documentation is so confusing and often leads to no where. Their Tutorials absolutely sucks. No where was it mentioned that we would connect over SSH. Thanks a LOT mate.

[rafaelrodrigues]

Thank you so much, man!

I spent a whole afternoon trying to connect to my database, and here I was thinking that another morning would be wasted. I'm using DBeaver and Postgre, but with your help I could do it!

For those using DBeaver, the SSH information goes into the "Network" tab.

[rcapilli]

Thanks for this brotha. Been banging my head trying to figure out why it couldn't connect.

[jmonit]

One important point I would like to mention is sometimes mysql workbench doesn't connect right away. I got SSH tunnel error many times. To get rid of it go to the security groups of RDS instance and set inbound rules to anywhere instead of fixed IP. After this you should be able to connect to AWS Db via Mysql Workbench. I finally figured it out after 4 days of toiling So thought would share it with you guys. Cheers :)

[ankitamitkari]

You are such a savior.. thank you for making this video!!

[dalecooper]

Still works like this ... Nice and thank you.

[KeithPickeringGuy]

I was trying to create a second db on my RDS instance and needed to know how to connect. Thanks!!

[ChaseGouldMMA]

I do not understand why you must enter the ssh information for the ec2 instance? Does the ec2 instance need to be somehow associated with the rds before connecting to the rds with mysql workbench?

[knowledgeshift]

the user ID you used for EC2 is this the same for all people trying this method of connecting the database?

[bharathn]

does creating tables in sql reflect in aws?

[NGamer]

I did exactly this but whenever I try to test the connection I get that it Cannot Open the SSH Tunnel. (Yes I tried what @Monit Jadhav said and the RDS instance inbound rules are set to anywhere)

[kedarnadkarny]

It is giving me an authentication error. and says only "public key allowed". Any solution?

[powerofpizzazz]

I got stuck in this tutorial because I never downloaded a key-pair value. (1:15)

[edwinfernandez]

What if the instance has no DNS setted...