RESELLERHow to Connect to AWS RDS using MySQL Workbench

How to Connect to AWS RDS using MySQL Workbench

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

  1. Create a MySQL Database on AWS RDS
  2. Install MySQL Workbench
  3. Open MySQL Workbench
  4. Setup New Connection
  5. 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.

How to Connect to AWS RDS using MySQL Workbench

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.

How to Connect to AWS RDS using MySQL workbench 2

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-

MySQL Workbench

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-

How to Connect to AWS RDS using MySQL workbench 4

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.

How to Connect to AWS RDS using MySQL workbench 5

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-

MySQL Dashbaord RDS connection

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.

How to Connect to AWS RDS using MySQL workbench 7

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 –

  • Follow Us On
  • Share this post with your friends

Suggested Read:

Latest news

Next-generation secure, defined internet with SCION architecture

The internet was built in more simple, innocent times and was seized on by a curious mixture of visionaries,...

Five things critical to the future of SAP and their co-CEOs

Just a few days ago, SAP announced earnings and a significant change to their CEO leadership. After a good...

Next-generation secure, defined internet with SCION architecture

The internet was built in more simple, innocent times and was seized on by a curious mixture of visionaries,...

Must read

Top 10 CIO Trends for 2019

As we get ready to close out 2018 and...

Are the cloud wars over or just getting started?

One of the biggest opportunities for enterprises large and...

You might also likeRELATED
Recommended to you