How do I connect to my Amazon RDS for MySQL instance by using MySQL Workbench?

2 minute read
0

I want to connect to my Amazon Relational Database Service (Amazon RDS) DB instance that's running MySQL using MySQL Workbench.

Resolution

Follow the steps below to connect MySQL Workbench to your Amazon RDS DB instance:

  1. Download and install MySQL Workbench.
  2. Open MySQL Workbench, and then choose the sign beside MySQL Connections to set up a new connection.
  3. In the Setup New Connection dialog box, enter a name for your connection.
  4. In the Parameters section, enter these details:
    Host name: Enter the RDS endpoint.
    Port: Enter the Port number.
    Username: Enter the primary user.
    Note: You can get these details from the Amazon RDS console. From the Databases section, choose Instances, and then select the instance that you are connecting to. From the Connectivity and Security tab, choose Configuration. The primary user is listed here.
  5. Choose Test Connection.
  6. In the pop-up window that appears, enter the password that you configured when you created the DB instance, and then choose OK.
  7. After testing your connection, from the Setup new connection dialog box, choose OK to save the connection.

If you receive an error when you test the connection, check that you configured the network correctly.


Related information

How can I troubleshoot connectivity to an Amazon RDS DB instance that uses a public or private subnet of a VPC?

Scenarios for accessing a DB instance in a VPC

Controlling access with security groups

AWS OFFICIAL
AWS OFFICIALUpdated a year ago
2 Comments

Can I connect using this method if I have disabled Public Access

Glue
replied 6 months ago

Thank you for your comment. We'll review and update the Knowledge Center article as needed.

profile pictureAWS
MODERATOR
replied 6 months ago