This topic describes how to connect to a MySQL DB System with MySQL Workbench.
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
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 Section 3.4, “Viewing DB System Details”.
The host name of the MySQL DB System as defined on the MySQL DB System Details page. See Section 3.4, “Viewing DB System Details”.
To connect to a DB System from MySQL Workbench:
In MySQL Workbench, select Connect to Database to open the Connect to Database dialog.>
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
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.
Clickto establish the connection.