doc-exports/docs/opengauss/umn/opengauss_trial.html

Example: Using DAS to Connect to an Instance and Execute SQL Statements

This section describes how to create a GaussDB instance with the minimum specifications and execute basic SQL syntax.

Creating an Instance

1. Log in to the console.
2. Click in the upper left corner and select a region.
3. Click on the left and choose Databases > GaussDB.
4. On the Instances page, click Create DB Instance.
5. Configure the basic information, such as the instance name.
6. Configure instance specifications.

7. Select a VPC and security group for the instance and configure the database port.

   The VPC you selected must contain sufficient subnets.

8. Configure the administrator password and parameter template.

9. Click Next. On the displayed page, confirm the information and click Submit.
10. Go to the instance list.

    If status of the instance becomes available, the instance has been created.

Connecting to an Instance Through DAS

1. Log in to the console.
2. Click in the upper left corner and select a region.
3. Click on the left and choose Databases > Data Admin Service.
4. In the navigation pane on the left, click Development Tool to go to the login list page.
5. Click Add Login.
   

   After the database is created, the root user is added by default. You do not need to create a root user.

6. Set DB Engine to GaussDB, retain the default value of Source Database, and configure required parameters.

   You are advised to enable Collect Metadata Periodically and Show Executed SQL Statements.

   If a message is displayed indicating that a connection has been established, go to 9.

7. Click Test Connection.

   If a message is displayed indicating connection successful, continue with the operation. If a message is displayed indicating connection failed and the failure cause is provided, make modifications according to the error message.

8. Click OK.
9. Locate the added instance, click Log In in the Operation column.

10. Access the SQL query page.

Getting Started with SQL

1. Create a database user.

   Only administrators that are created during the instance installation can access the initial database by default. You can also create other database users.

   CREATE USER joe WITH PASSWORD "xxxxxxxxx";

   If information similar to the following is displayed, the user has been created.

   

   In this case, you have created a user named joe, and the user password is xxxxxxx.

2. Create a database.

   CREATE DATABASE db_tpcds;

   If information similar to the following is displayed, the database has been created.

   

   Switch to the newly created database in the upper left corner.

   

3. Create a table.
   • Run the following command to create a schema:

     CREATE SCHEMA myschema;

   • Create a table named mytable that has only one column. The column name is firstcol and the column type is integer.

     CREATE TABLE myschema.mytable (firstcol int);

   • Insert data to the table.

     INSERT INTO myschema.mytable values (100);

   • View data in the table.

     SELECT * FROM myschema.mytable;

   Note:

   • By default, new database objects, such as the mytable table, are created in the $user schema.
   • In addition to the created tables, a database contains many system catalogs. These system catalogs contain cluster installation information and information about various queries and processes in GaussDB. You can collect information about the database by querying the system catalogs.

4. In the db_tpcds database, run the following statement as user root to grant all permissions of the db_tpcds database to user joe:

   GRANT ALL ON DATABASE db_tpcds TO joe;

   GRANT USAGE ON schema myschema TO joe;

   GRANT ALL ON TABLE myschema.mytable TO joe;

5. Log in to the db_tpcds database as user joe.

6. After login, insert data into the table and verify the data.

   INSERT INTO myschema.mytable values (200);

   SELECT * FROM myschema.mytable;

   

Parent topic: Getting Started

<script language="JavaScript"> </script>