DocsICP FilingConsole
Documentation
Home Page ApsaraDB for OceanBase (Deprecated) Use Cases Feature tutorials Explore storage compression and real-time analysis Create a MySQL database

Create a MySQL database

Updated at:
Copy as MD
Product
My Favorites

This topic describes how to create a database named tutorial_database in the tutorial_mysql tenant. The MySQL mode of OceanBase is compatible with most features and syntax of MySQL 5.7 and 8.0. For more information, see MySQL compatibility.

Procedure

  1. In the navigation pane on the left, click Tenant Management.

  2. On the Tenant Management page, click the tutorial_mysql tenant to open the tenant workbench.

  3. In the upper-right corner, click New Database and configure the following parameters as needed:

    Parameter

    Description

    Database Name

    tutorial_database

    Character Set

    Select the default utf8mb4_general_ci.

    Note

    The UTF8MB4 and GBK character sets are supported. UTF8MB4 is a Unicode character encoding that supports the latest Unicode standard and can represent all characters, including emojis. GBK is a character encoding for Chinese characters. It includes most Chinese characters, common symbols, and numbers. It is an extension of GB2312 and is part of the Chinese national standard.

  1. Click Create. The new database appears on the database management page.

Previous：Create a MySQL tenantNext：Create an account (MySQL database user)