Create a database

This topic describes how to create a database in the MySQL mode of OceanBase Database by using an SQL statement.

Prerequisites

You have the CREATE privilege. For information about how to view the privileges of the current user, see View user privileges. If you do not have the CREATE privilege, contact the administrator to obtain the privilege. For more information, see Grant direct privileges.

Procedure

1. Log on to a MySQL tenant of the cluster.

2. Use the CREATE DATABASE statement to create a database.

   Here is an example:

   • Create a database named test2 and specify the character set as UTF8.

     obclient> CREATE DATABASE test2 DEFAULT CHARACTER SET UTF8;
     Query OK, 1 row affected
     

   • Create a database named test3 that supports read and write operations.

     obclient> CREATE DATABASE test3 READ WRITE;
     Query OK, 1 row affected
     

   • Create a read-only database named test4.

     obclient> CREATE DATABASE test4 READ ONLY;
     Query OK, 1 row affected
     

References

For more information about the syntax of the CREATE DATABASE statement, see CREATE DATABASE.