Updated on 2024-09-13 GMT+08:00
Creating a GaussDB Database

Creating a GaussDB Database

Scenario

After creating a GaussDB instance, you can create more databases as required. Database creation should comply with relevant design specifications. For details, see the Development and Design Proposal.

You can create a database by using either of the following methods:

Creating a Database Through DAS

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner of the page and choose Databases > GaussDB.
  4. On the Instances page, locate the DB instance you want to log in to and click Log In in the Operation column.

    Alternatively, click the DB instance name on the Instances page. On the displayed Basic Information page, click Log In in the upper right corner of the page.

  5. On the Custom Login page, select the node to be logged in to. Enter the correct database username and password, and click Test Connection. After the connection test is successful, click Log In.
  6. Create a database.

    • In the database list of the homepage, click Create Database. In the displayed dialog box, enter a database name and specify a character set, template, and other required parameters. Click OK.
    • Alternatively, on the top menu bar, choose SQL Operations > SQL Query. Run the following command to create a database:

      create database database_name;

Creating a Database Using SQL Statements

You can also use the CREATE DATABASE command to create a database.