5.2.3 Connecting with MySQL Workbench

This topic describes how to connect to a MySQL DB System with MySQL Workbench.

Prerequisites:

• A machine or compute instance with internet connectivity for connecting to the MySQL DB System.

• A MySQL Workbench client installed on your machine or compute instance. For instructions, refer to the MySQL Workbench Reference Manual.

• A MySQL user account on the MySQL DB System to connect with. You can use the MySQL Administrator user that you specified when creating the DB System or a MySQL user account created on the DB System using CREATE USER .

• A public-facing IP address for your machine or compute instance that is permitted to connect to the DB System. Allowed Client Addresses information is available on the MySQL DB System Details page. See Viewing DB System Details.

• The host name of the MySQL DB System as defined on the MySQL DB System Details page. See Viewing DB System Details.

To connect to a DB System from MySQL Workbench:

1. In MySQL Workbench, select Database > Connect to Database to open the Connect to Database dialog.

2. Enter the connection details.

   • Connection Method: The connection method. Select Standard (TCP/IP).

   • Hostname: The host name of the MySQL DB System

   • Port: The port address that the MySQL DB System is listening on. Use the default 3306 port.

   • Username: The user name of the MySQL user that will connect to the DB System

   • Password: The password of the MySQL user

   • Default Schema: Optionally, specify a default schema. Leave blank to select it later.

3. Click OK to establish the connection.

Parent topic: Connecting from a Client