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

2 minute read
0

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

Resolution

To connect your MySQL Workbench to your Amazon RDS DB instance, complete the following steps:

  1. Download and install MySQL Workbench from the MySQL website.
  2. Open MySQL Workbench, and then choose the plus sign next to MySQL Connections.
  3. In the Setup new connection dialog box, enter a name for your connection.
  4. In the Parameters section, enter the following details:
    For Host name, enter the RDS endpoint.
    For Port, Enter the Port number.
    For Username, Enter the primary user.
    Note: You can find the primary user from the Amazon RDS console. In the Databases section, choose Instances, and then select the instance that you're connecting to. On the Connectivity and Security tab, choose Configuration.
  5. Choose Test connection.
  6. In the pop-up window, enter the password that you configured when you created the DB instance, and then choose OK.
  7. In the Setup new connection dialog box, choose OK to save the connection.

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

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

2 Comments

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

replied a year ago

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

profile pictureAWS
MODERATOR
replied a year ago