How to Connect to AWS RDS using MySQL Workbench
Dear Reader, I hope you are doing amazing. In my last post, we saw how to setup a MySQL database instance on AWS RDS. In this post, you will see how to connect to the same MySQL we created on AWS RDS using a popular DB client MySQL workbench installed in our local system for example windows 10.
So are you ready?
Alright, let’s go.
Don’t want to miss any posts from us? join us on our Facebook group, and follow us on Facebook, Twitter, LinkedIn, and Instagram. You can also subscribe to our newsletter below to not miss any updates from us.
Steps to Connect to AWS RDS using MySQL Workbench
- Create a MySQL Database on AWS RDS
- Install MySQL Workbench
- Open MySQL Workbench
- Setup New Connection
- Verify Connectivity
Step 1: Create a MySQL Database on AWS RDS
Before you can connect to AWS RDS using MySQL workbench, you need one database instance setup done. If you already have that, great.
If not, use my tutorial to setup a MySQL on AWS RDS.
Once the database is up and running, grab the database endpoint info.
Can you notice the Endpoint and Port? Yeah?
Note them down as we’ll need them while connecting to AWS RDS using MySQL workbench.
Step 2: Install MySQL Workbench
Navigate to MySQL workbench official downloads page and download it for your operating system.
Follow the wizard and complete the MySQL workbench installation.
Step 3: Open MySQL Workbench
Open the MySQL workbench and click on the + icon beside MySQL Connections as shown below-
Step 4: Setup New Connection
Once you click on the + icon, it will open the Setup new connection dialogue. We need to put up details like-
Hostname: Remember we noted down the RDS endpoint.
Port: We have the Port number as well.
Username: User name that you created while setting up MySQL on RDS
Fill up the details shown below-
After entering the details, as soon as you click Test Connection, you will be prompted for the password as shown above. Provide the password you set for your DB user and click OK.
You will see, that you are successfully connected to AWS RDS from your MySQL workbench.
Once this dialogue closes, Click OK once again to add this setting to the MySQL workbench dashboard.
And, it gets added to your dashboard like below-
This setting is saved and you can connect to this AWS RDS database instance from your MySQL workbench anytime.
Step 5: Verify Connectivity
Double-click on the above setting and you will be presented with the management dashboard. Let’s create a new schema as we don’t have any as of yet.
Click on the database icon shown below, provide a schema name and click Apply.
Click Apply and click Finish.
Schema gets created as you can see. Next, you can go ahead and create a table, insert data and whatever you need.
Conclusion
In this quick tutorial, you learned How to Connect to AWS RDS using MySQL workbench from your local system.
We saw the different parameters available and what to enter for those details. Finally, we tested the connection and saved it for later use.
We also connected to AWS RDS from the MySQL workbench saved connection and created a schema.
I hope you enjoyed the tutorial and were able to Connect to AWS RDS using MySQL workbench. Let me know in the comments in case you face any issues.
Enjoyed the content?
Subscribe to our newsletter below to get awesome AWS learning materials delivered straight to your inbox.
Meanwhile, you can also –
