This topic describes the methods for connecting to OceanBase Database in MySQL mode, including MySQL client (mysql), OceanBase Client (OBClient), and OceanBase Developer Center (ODC).
mysql
mysql is a MySQL command-line interface (CLI) tool that must be installed separately. OceanBase Database tenants include MySQL tenants and Oracle tenants. You can access a MySQL tenant from mysql.
After you connect to OceanBase Database, you can run mysql O&M commands and SQL statements on the CLI of mysql for the following purposes:
Calculating, storing, and generating query results
Creating database objects and checking and modifying object definitions
Managing databases and modifying parameters
OBClient
OBClient is an interactive query tool that supports batch processing. It must be installed separately. OBClient provides a CLI and acts as the client when it is connected to OceanBase Database. It supports Oracle and MySQL tenants in OceanBase Database.
Before you use OBClient to connect to an OceanBase Database tenant, you must specify the connection information of the tenant. After you connect to OceanBase Database, you can use OBClient to run some database commands (including general MySQL commands) and execute some SQL and PL/SQL statements for the following purposes:
Calculating, storing, and generating query results
Creating database objects and checking and modifying object definitions
Developing and running batch processing scripts
Managing databases and modifying parameters
ODC
ODC is an enterprise-level database development platform tailored for OceanBase Database.
ODC is compatible with both MySQL and Oracle tenants in OceanBase Database. It provides database developers with various features, such as daily development, WebSQL-based workspace, SQL diagnostics, session management, and data import and export.