Connect to OceanBase Database by using Navicat

Navicat is a universal database client. It connects to a database through the Java Database Connectivity (JDBC) driver provided by this database. It supports normal relational databases, non-relational databases, and distributed databases.

You can connect to a MySQL tenant of OceanBase Database by using the OceanBase or MySQL driver that comes with Navicat. This topic describes how to connect to a MySQL tenant of OceanBase Database by using the OceanBase driver of Navicat.

Prerequisites

• You have downloaded and installed Navicat. You can download the Navicat installation package for your operating system from the Navicat Premium website.

• The IP address of the OBServer node to be connected has access to the server where Navicat is installed.

• You have installed OceanBase Database and created a MySQL tenant.

Procedure

1. Choose Connection > OceanBase > OceanBase Database Enterprise Edition (MySQL Mode) to go to the New Connection dialog box.

2. In the New Connection dialog box, specify the information about the database to be connected and then click Test Connection.

   Notice

   You can connect to OceanBase Database by using an IP address or an OceanBase Database Proxy (ODP). When you use an IP address, enter the port number specified by the mysql_port parameter. The default port number is 2881. When you use an ODP, enter the port number specified by the proxy_port parameter. The default port number is 2883.

3. If Connected is displayed in the Test Connection pop-up window, the database can be connected. Then, click Save.

4. Double-click the database name on the Database Navigator tab. If the database instances appear under the database, you have connected to OceanBase Database.

More information

For any problems encountered when you connect to OceanBase Database by using Navicat, see related information in Navicat Documentation.