To create a connection to a MySQL Database
Open a command prompt and run oci dbtools connection
create-mysql-database to create a new Database Tools connection within
the specified compartment:
oci dbtools connection create-mysql-database -c <target_compartment_ocid> --user-name <database_user> --user-password-secret-id <vault_secret_ocid> --connection-string <connection_string> --display-name <connection_name> Note
This example assumes the required secret in a vault already exists.
This example assumes the required secret in a vault already exists.
For example:
oci dbtools connection create-mysql-database -c ocid1.compartment.oc1..example1example25qrlpo4agcmothkbgqgmuz2zzum45ibplooqtabwk3zz --user-name "example-user" --user-password-secret-id ocid1.vaultsecret.oc1.phx.example1secrettxiu7mwuabcdefxl67fj5niy4akfzsabcdefzf3423ya --connection-string "mysql://public-ip-or-fqdn:3306/exampledatabase" --display-name example-connection