How to Connect to AWS RDS Database with MySQL Workbench

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

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

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

Thank you, It help me a lot!

it helped.

does creating tables in sql reflect in aws?

What if the instance has no DNS setted...

THANK YOU!!!!!!!

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)

Quick and to the point. Thank you.

I f*kn love you!

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.

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?

THANK YOU

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!

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 :)

Awesome!

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.

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

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

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

thank you!!!