Client OceanBase Developer Center (ODC) can connect to MySQL-compatible tenants of OceanBase Cloud. This topic describes the prerequisites and connection procedure.
Prerequisites
You have installed Client ODC. For more information, see Install Client ODC.
You have obtained the connection string of the target MySQL-compatible tenant in an OceanBase Cloud instance. For more information, see Obtain the connection string.
Procedure
Open Client ODC. Click the plus (+) sign and select OceanBase MySQL Compatible.
In the Create Data Source panel, specify the following information based on the obtained connection string mentioned in the "Prerequisites" section.
ParameterDescriptionIntelligent Parsing (optional) You can paste the connection string to the field. ODC automatically identifies the string and populates the corresponding fields. Endpoint - Host IP/Domain Name: the IP address or domain name of the server where the target database is located.
- Port: the port number of the server where the target database is located.
Database Account - Database User Name: an account created in the tenant. In MySQL compatible mode, this account must have the permission to access the default database.
- Database Password: the password of the account created in the tenant. You can click Test Connection to test whether you can connect to the target database.
Note
- An error will be returned if the configurations such as the username, password, or network settings are invalid.
- You can connect only to a database in the current tenant. Otherwise, an error indicating test failure will be returned.
- Before you save the configurations, you can click Test Connection to test the database connection. If the database username and password are correct, the system returns a message indicating that the connection succeeded. In ODC V4.0.0 and later, you can save the connection without setting the database account and password.
Environment The type of the environment. Valid values: dev(development),sit(system integration test), andprod(production).Click OK in the lower-right corner of the panel. In the dialog box that appears, enter a data source name.