How to connect to the AWS RDS database with MySQL Workbench is answered by our top experts. Read on to learn more. 

At Bobcares, we offer solutions for every query, big and small, as a part of our AWS Support Services.

Let’s take a look at how our AWS Support Team is ready to help customers with how to connect to AWS RDS database with MySQL Workbench.

How to connect to AWS RDS database with MySQL Workbench

Let’s have a look at AWS RDS and MySQL Workbench before we get into connecting an AWS RDS database to MySQL Workbench.

AWS RDS or AWS Relational Database Service is a service by Amazon Web Services. It is a managed database service that launches a highly available as well as scalable database cluster. Furthermore, it offers various database engines like:

• Amazon Aurora
• MariaDB
• MySQL
• MS SQL Server
• Postgre SQP
• Oracle

Our AWS Support team would like to point out that AWS does not offer shell access to the data server. Instead, it offers us a connection string to connect to it.

On the other hand, MySQL Workbench is a desktop application that enhances visibility within relational database servers via an easy-to-use graphical UI. Moreover, it offers a query tool that performs SQL queries to the database server. Today, our AWS Support Team is going to demonstrate how to connect to AWS RDS database with MySQL Workbench.

1. To begin with connecting an RDS database to MySQL Workbench, download and install MySQL Workbench.
2. Next, set up a new connection by opening MySQL Workbench and selecting the plus sign next to MySQL Connections.
3. Then, enter a name for the new connection in the Setup New Connections dialog box.
4. After that, enter the following information in the Parameters section:
   • • Hostname: RDS endpoint
     • Port: Port number
     • Username: Master user

   According to our Support Techs, we can access these details from the AWS RDS console. We have to navigate to Database > Instances and select the instance we are connecting to. Then head to the Connectivity and Security tab and select Configuration.
5. Then, select Test Connection.
6. Now, we have to enter the configured password that we created at the time of creating the DB instance and select Ok.
7. Once the testing is successful, select Ok to save the AWS RDS to MySQL Workbench connection.

If you are still unable to connect to AWS RDS with MySQL Workbench, drop us a line and our technicians will resolve the issue in no time.

[Need assistance with another query? We are available 24/7.]

Conclusion

In a nutshell, our skilled AWS Support Engineers at Bobcares demonstrated how to connect to AWS RDS database with MySQL Workbench.