Connecting from MySQL Workbench - Amazon Relational Database Service

Connecting from MySQL Workbench

To connect from MySQL Workbench
  1. Download and install MySQL Workbench at Download MySQL Workbench.

  2. Open MySQL Workbench.

    The Welcome screen in MySQL Workbench.
  3. From Database, choose Manage Connections.

  4. In the Manage Server Connections window, choose New.

  5. In the Connect to Database window, enter the following information:

    • Stored Connection – Enter a name for the connection, such as MyDB.

    • Hostname – Enter the DB instance endpoint.

    • Port – Enter the port used by the DB instance.

    • Username – Enter the user name of a valid database user, such as the master user.

    • Password – Optionally, choose Store in Vault and then enter and save the password for the user.

    The window looks similar to the following:

    The Manage Server Connections window in MySQL Workbench.

    You can use the features of MySQL Workbench to customize connections. For example, you can use the SSL tab to configure SSL/TLS connections. For information about using MySQL Workbench, see the MySQL Workbench documentation. Encrypting client connections to MySQL DB instances with SSL/TLS, see Encrypting client connections with SSL/TLS to MySQL DB instances on Amazon RDS.

  6. Optionally, choose Test Connection to confirm that the connection to the DB instance is successful.

  7. Choose Close.

  8. From Database, choose Connect to Database.

  9. From Stored Connection, choose your connection.

  10. Choose OK.