Overview
On the homepage of OceanBase Developer Center (ODC), you can view the connections you have created on the Private Connection tab and the public connections that you have the permission to access on the Public Connection tab. Connections are listed for easy viewing and management.
You can click Public Connection in the upper-left corner to switch to the Public Connection tab and view the public connections that you have the permission to access.
For more information about how to create and manage a public connection, see Manage public connections.
View the information of private connections
The information of private connections is displayed in a list. In the upper-right corner of the Private Connection tab, you can perform the following operations:
- Click the refresh icon to manually refresh the list.
- Click All Modes to select the MySQL or Oracle mode.
- Search for connections by using the search box.
The following table describes columns of the list of private connections.
| Column | Description |
|---|---|
| Connection Name | The name of the connection and the host and port information. You can click the name of a connection to go to the corresponding connection management page. The icon before the connection name indicates the status of the connection. Blue indicates valid, red indicates invalid, and gray indicates that the database password is not saved. |
| Cluster | The cluster information. You can click the filter icon to filter the cluster information. If you select  Empty , you can filter connections that do not belong to any clusters. |
| Tenant | The tenant information. You can click the filter icon to filter the tenant information. If you select Empty , you can filter connections that do not belong to any tenants. |
| Tag | The tag of the connection. You can create a tag and assign it to a connection. You can assign only one tag to each connection. |
| Operation Time | The time when the connection was edited, or the time when the connection was created if the connection has not been edited. |
| Actions | You can click the More icon to display actions you can take: Open , Edit , Copy , and Delete . |
View connection history
In the upper-right corner of the Private Connection tab, click History . The Historical Opened Windows panel appears.
The panel shows a list that has the following columns.
| Column | Description |
|---|---|
| Connection Name | The name of the connection you accessed. |
| Database/Schema Name | The name of the database or schema that you accessed by using the connection. |
| Recently Opened At | The time when you last accessed the connection. |
| SQL/PL Window | The workspace window that you created when you accessed the connection. Move the pointer to a window name, and the script that you edited in the window is displayed. |
| Actions | You can click Open to resume the connection in a new window. The corresponding workspace window and its contents are also resumed. |
Note
By default, the historical records of connections are retained for 48 hours in the panel.
Set a tag
ODC allows you to create a tag and assign it to a connection. You can assign only one tag to each connection. Alternatively, you can move the pointer in the tag column of the row where the target connection is located in the connection list and click Set Tag . The drop-down list provides options for you to create, set, and manage tags.
Create a tag: You can create a tag by using the following two methods:
Click Set Tag next to the Connection Name field in the Create Connection panel.
Move the pointer in the tag column of the row where the target connection is located in the connection list, click Set Tag and click Create Tag in the drop-down list. On the Tags page, specify the name and color of the tag, and click the tick icon to complete the creation.
Set a tag: select the target tag from the drop-down list that displays all the tags that you created, and modify related parameters to finish the setting.
Manage tags: click the Settings icon in the upper-right corner of the drop-down list to go to the Tags page, where you can edit or delete created tags.
Pin a private connection to the top
By default, the connections in the connection list are sorted by their creation times, with the most recently created connection on top. The list does not support custom sorting, but you can pin frequently used connections to the top.
You can click the flag 
next to the name of a connection to pin the connection to the top. This turns the flag to yellow. You can click the flag again to unpin the connection from the top.
Edit a private connection
Click Edit in the Actions column of the target connection. The Edit Connection panel appears, which has the same structure as the Create Connection panel and displays the configuration information of the current connection. You can edit the information displayed in the Edit Connection panel.
Before you change Database Password , you must first click Change Password next to the password box. To abort the current change, click Cancel next to the password box, and the input in the password box is restored to its original value.
Copy a private connection
Click Copy in the Actions column of the target connection. The Create Connection panel appears. The copied information is automatically filled in the panel. This allows you to quickly create a connection by modifying existing information.
The copy feature allows you to easily create database connections having similar information.
Delete a private connection
To delete a connection, click Delete in the Actions column of the target connection.
For example, when the connected database no longer exists or you do not need to access the connected database, you can directly delete the corresponding connection.
Other operations
In addition to the management actions that the Private Connection tab provides, after you go to the management page of a database connection, the homepage menu icon 
in the top navigation bar further provides the following buttons:
Open Connection in New Window : After you click a connection in the connection list that appears, ODC opens the connection in a new window.
Connections : Click Connections to open the ODC homepage in a new window. On the ODC homepage, you can view and manage the configuration information of all connections.
Reload : Click this button to reload the current page.
Exit Connection : Click this button to exit the current connection and go to the ODC homepage.
Information such as the connection name, schema (in Oracle mode), and database name (in MySQL mode) appears in the top navigation bar of the workspace.
Move your pointer over the connection name in the top navigation bar. In the tooltip that appears, you can see information in fields such as Connection Mode , Host/Port , Cluster/Tenant , and Database Username .
Click the drop-down arrow next to the displayed schema name or database name. In the drop-down list that appears, click a schema or database name to go to the target schema or database.
