Pre-General Availability: 2023-05-24
Access to a tenancy, a compartment, a DB system (OCID), and a Bastion.
A configuration file with required entries (
key_file). For example:
[DEFAULT] user=ocid1.user.oc1..aaaaaaaab ... fingerprint=48:57:a4 ... tenancy=ocid1.tenancy.oc1..aaaaaaaaas ... region=us-ashburn-1 key_file=~.oci/oci_api_key.pem
Add the configuration and PEM files to the
.ocidirectory of the account holder.
To configure this type of connection, you need to specify information in multiple tabs.
Host Name or IP Address
Use the host name
Establishes the connection using classic MySQL protocol.
Establishes the connection using X Protocol.
The TCP/IP port on which MySQL Server is listening. The default values are:
3306 for classic MySQL protocol
33060 for X Protocol
The MySQL user account to use for the connection.
Optional password for the account used. If you enter no password here, you are prompted to enter the password when the MySQL Shell for VS Code extension attempts to establish the connection. MySQL Shell for VS Code can store the password for a connection using a secret store, such as a keychain. Use the Clear Password to remove a stored password.
Connect to OCI DB server using MDS settings
When you enable this option, the MDS tab appears.
Select a profile from the list. The list consists of the different profiles that you defined previously in your configuration file.
SSH Private Key File
Your existing SSH private key, which is discovered automatically. The name is shown as
SSH Public Key File
Your existing SSH public key, which is discovered automatically. The name is shown as
MySQL DB System OCID
Add the OCID of an existing DB System to use for the connection. To copy an OCID from the console:
From the navigation menu, and select Databases.
Under MySQL, click DB Systems to open a list of DB Systems in the compartment and select an entry to use for the connection.
From the DB System Information tab, locate the OCID entry under General Information, and click
Select the OCID of an existing Bastion to use for the connection or create a new Bastion in the compartment.
MySQL DB System Name
The connection discovers the DB System name automatically.
The connection discovers Bastion name automatically.