Connecting to a DB instance Through DAS

Prerequisites

You have purchased a DB instance. If you have not, purchase one by referring to Buying a DB Instance.

Procedure

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(for MySQL).
4. On the Instances page, locate the target DB instance and click Log In in the Operation column.
   Figure 1 Logging in to the DB instance
   

5. Enter the database username and password and click Test Connection. After the connection test is successful, click Log In. Then you can access and manage your database.
   Figure 2 Login page
   

Follow-up Operations

After logging in to a DB instance through DAS, you can manage your database.

1. Create a database.

   After logging in to GaussDB(for MySQL), click Create Database on the home page, enter database information, and click OK.

   Figure 3 Creating a database
   

   Database test is used as an example. After the database is created, you can view it in the database list.

   Figure 4 Viewing the created database
   

2. Create a table.

   In the row containing the target database, click Create Table in the Operation column.

   Figure 5 Creating a table
   

   On the Basic Information tab, set the required parameters.

   Figure 6 Entering basic table information
   

   Click Next and enter column information.

   Figure 7 Entering column information
   

   Click Create. In the SQL preview window, view the SQL statement for creating a table and click Execute.

   Figure 8 Previewing the SQL statement for creating a table
   

   After the SQL statement is executed successfully, you can view the created table in the table list.

   Figure 9 Viewing the created table
   

3. Create a user and grant all permissions on the database created in 1 to the user.

   On the top menu bar, choose Account Management > User Management.

   Figure 10 User management
   

   Click Create User and enter user information and authorization information.

   Figure 11 Creating a user
   
   Figure 12 Entering user information and authorization information
   

   Username user is used as an example. In the Object Permissions area, all permissions on the table (table1) in the database (test) are granted to the user (user).

   Figure 13 Previewing the SQL statement for creating a user
   
   Figure 14 User created
   

4. Log in to the database as the created user and write data into the database.

   On the DAS development tool page, add a database login as user user. Click Log In in the Operation column to log in to the DB instance.

   Figure 15 Adding a login as user
   

   In the row containing the test database, click Query SQL Statements in the Operation column. The SQL execution window is displayed.

   Figure 16 Accessing the SQL execution window
   

   Run the following SQL statement in the SQL input box to query data in table1:

   SELECT * FROM table1;

   Figure 17 Viewing table data
   

   There is no data in table1.

   Run the following SQL statements to write several data records to table1:

   insert into table1(id, name, age) values(1, 'sam', 30);

   insert into table1(id, name, age) values(2, 'cidy', 25);

   insert into table1(id, name, age) values(3, 'lily', 27);

   Figure 18 Writing data to the table
   

   Data has been written into the table.

   Run the following SQL statement again to check whether there is data in table1:

   SELECT * FROM table1;

   Figure 19 Verifying the written data