Create a database

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

Prerequisites

Ensure that you have the CREATE privilege. For information about how to view your privileges, see View user privileges. To acquire the CREATE privilege, contact the administrator. For more information about how to grant privileges to a user, see Modify user privileges.

Procedure

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

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

   Examples:

   • 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
     

More information

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