Creating a Database

Scenarios

After your GaussDB(for MySQL) instance is created, you can create databases on it.

Constraints

  • This operation is not allowed when another operation is being performed on your DB instance.

  • After a database is created, its name cannot be changed.

Procedure

  1. Log in to the management console.

  2. Click image1 in the upper left corner and select a region and a project.

  3. Click Service List. Under Databases, click GaussDB(for MySQL).

  4. On the Instances page, click the target DB instance.

  5. In the navigation pane, choose Databases. On the displayed page, click Create Database. In the displayed dialog box, enter a database name, select a character set, and authorize permissions for users. Then, click OK.

    Table 1 Parameter description

    Parameter

    Description

    Database Name

    The database name can consist of up to 64 characters. Only letters, digits, hyphens (-), and underscores (_) are allowed. The total number of hyphens (-) cannot exceed 10.

    Character Set

    Select a character set as required.

    User

    You can select one or more unauthorized users. If there are no unauthorized users, you can create one by referring to Creating a Database Account.

    Remarks

    The remarks can consist of up to 512 characters. It cannot contain carriage return characters and the following special characters: !<"='>&

  6. After the database is created, authorize or delete it on the Databases page. You can search for the desired database by character set and database name.