Check after deployment

After you deploy ODC, you can log on to ODC to check if everything is ok.

The graphic user interface (GUI) varies with the ODC version. This topic takes ODC V2.3.0 as an example. For other ODC versions, see User Guide of the corresponding version.

Log on to ODC

1. Log on to ODC from its access address.

   The access address is http://< IP address of the ODC server >:8989.

2. On the logon page that appears, use the default account admin to log on to ODC. The default password is root. Change your password after your first logon.

Connect to OceanBase Database through ODC

1. After you log on to ODC, click Create Connection to display the Create Connection page.

2. On the Create Connection page, you must enter or select the following information. If you have an OceanBase Database connection string, all the following information can be obtained from the connection string (mysql -h Host name -P Port number -u Database username@Tenant name # Cluster name -D Default database -p ' Database password ') or directly use the smart parser provided on the page to fill in the information.

   Item	Description
   Region	Select the region of the connection example. The options are Public Cloud (database instances on Alibaba Cloud) and Private Cloud (database instances built in your own environment).
   Connection Mode	Select MySQL or Oracle.
   Connection Name	The name of the connection.
   Endpoint	Host Name: Obtain the host name from the tenant information page. Port Number: Obtain the port number from the tenant information page. Cluster: Enter the name of the cluster where the database to be connected is located. Tenant: Enter the name of the tenant to which the database to be connected belongs.
   Default Database (optional)	When you connect to a database in a MySQL tenant, you can select the default database to be used in this connection. This field is not required when you connect to a database in an Oracle tenant.
   Database Username	The database account created in the tenant. In a MySQL tenant, the account must have permission to access the default database.
   Database Password	The password of the database account created in the tenant. Click Test Connection next to the database password field to test whether the target database can be connected. If the configuration information is incorrect, an error message appears, indicating that the username or password that you entered was incorrect or a network error occurred. You can only connect to a database in the current tenant. Otherwise, a test failure error will be returned.
   Intelligent DNS Resolution	Paste the connection string information. Then, ODC automatically recognizes and fills in the connection information.
   SQL Query Timeout Value	Click Advanced Configuration in the lower part of the page to display this item. You can customize the SQL query timeout value. Default value: 60s. The query session is automatically terminated when the timeout value exceeds the specified value.
   Query SYS Tenant View	Click Advanced Configuration in the lower part of the page to display this item. Account: The account that has the permission to view the SYS tenant view. Password: The password of the account. After you enter the account and password, click Test Connection next to the database password field to test whether the account and password are correct. For ODC V2.3.0 and later versions, you need to configure the root account if you want to import and export data and view the partition information.

   • Click Save in the lower part of the page to persist your configuration information in the ODC connection list. When you log on to ODC again, you can directly select the connection from the connection configuration list, and the connection configuration does not need to be tested successfully.

   • In the lower part of the page, ODC also provides the Copy Connection String button. After you click this button, ODC copies the connection information that you are editing into a connection string for you to obtain the configured connection information.

   • If you do not need to save the current connection configuration, click Cancel . Then, ODC displays a confirmation dialog box about whether to exit the Create Connection page.