Help Center/ TaurusDB/ User Guide/ Connecting to a DB Instance/ Connecting to a DB Instance Through DAS (Recommended)
Updated on 2025-10-27 GMT+08:00
View PDF
Share

Connecting to a DB Instance Through DAS (Recommended)

Data Admin Service (DAS) is a one-stop management platform that allows you to manage Huawei Cloud databases on a web console. It offers database development, O&M, and intelligent diagnosis, making it easy to use and maintain databases.

This section describes how to connect 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 > TaurusDB.
  4. On the Instances page, locate a DB instance and click Log In in the Operation column.

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

  5. Enter the login username and password and click Test Connection.

    Figure 1 Login page
    Table 1 Parameter description

    Parameter

    Description

    Login Username

    The default administrator is root.

    Password

    Enter the password you specified for the root user during instance creation. If you forget the password, reset it. For details, see Resetting the Administrator Password.

    Show Executed SQL Statements

    You are advised to enable Show Executed SQL Statements. If enabled, you can view the executed SQL statements under SQL Operations > SQL History and execute them again without entering the SQL statements.

  6. After the connection test is successful, click Log In. Then you can access and manage your databases.

Other Methods for Connecting to a DB Instance

FAQs

What Can I Do If the DAS Console Is Not Displayed After I Click Log In in the Operation Column of an Instance on the Instances Page?

Set your browser to allow pop-ups and try again.

What Should I Do If I Cannot Connect to My DB Instance Due to Insufficient Permissions?

  1. Error message: You do not have the required permission. The policy does not allow action das:connections:xxx.

    Error cause: Your account does not have the DAS FullAccess permission.

    Solution: Add the DAS FullAccess permission by referring to Creating a User and Granting Permissions.

  2. Error message: You do not have the permission to perform this operation. Contact your administrator to request the required permission.

    Error cause: Your account does not have the DAS FullAccess permission.

    Solution: Add the DAS FullAccess permission by referring to Creating a User and Granting Permissions.

  3. Error message: Your current account only has the read-only permission and cannot perform this operation. To ensure that you can use DAS smoothly, add the DAS Administrator permission.

    Error cause: Your account does not have the DAS FullAccess permission.

    Solution: Add the DAS FullAccess permission by referring to Creating a User and Granting Permissions.

What Should I Do If I Can't Connect to My TaurusDB Instance?

  1. Error message: Access denied for user 'user_name'@'100.xxx.xx.xx' (using password: YES).
    1. Error cause: The username or password of a TaurusDB database is incorrect.
      Solution: Check whether the username and password are correct. If you are not sure, log in to the GaussDB console to view the username and reset the password.

      Changing the password may affect services.

      If the username and password are correct, log in to the database using a client or CLI tool and run select * from mysql.user where user = 'user_name' to view the account. Make sure that the DAS CIDR block is within the CIDR block of the user. user_name @ % and user_name @100.% are two different users whose passwords and permissions are independent. Make sure to enter the password of user user_name @100.%.

    2. Error cause: The IP address of the DAS server is not in the whitelist of the login user.
      Solution: Log in to the database using the client or CLI tool, and create a user that can be used to access the database through DAS. 
      create user 'user_name'@'100.%' identified by 'password';
grant all privileges on *.* to 'user_name'@'100.%';
      1. Ensure that the IP address of the DAS server is in a CIDR block starting with 100. Add the IP address to the whitelist of the login user.
      2. Grant permissions to user user_name@100.% based on service requirements.
  2. Error message: Trying to connect with ssl, but ssl not enabled in the server

    Error cause: The SSL function is not enabled on the server.

    Solution: Run the following statement to check an SSL user is used. If yes, enable SSL on the TaurusDB instance details page. The user is an SSL user if the ssl_type field has a value.

    select user, host, ssl_type from mysql.user where user = 'user_name';
  3. Error message: Client does not support authentication protocol requested by server. plugin type was = 'sha256_password'

    Error cause: DAS does not allow you to connect to the database whose password is encrypted with SHA-256.

    Solution: Execute the following SQL statements to change the password encryption method to mysql_native_password.

    alter user 'user_name'@'%' identified with mysql_native_password by 'password';
  4. Error message: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

    Error cause: The network between the DAS server and the instance is disconnected.

    Solution: Contact technical support.

Follow-up Operations

After logging in to a TaurusDB instance through DAS, you can manage your databases.

  1. Create a database.

    After logging in to a TaurusDB instance, click Create Database on the home page, enter database information, and click OK.

    Figure 2 Creating a database

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

    Figure 3 Viewing the created database

  2. Create a table.

    Locate the database and click Create Table in the Operation column.

    Figure 4 Creating a table

    On the Basic Information tab, set the required parameters.

    Figure 5 Entering basic table information

    Click Next and enter column information.

    Figure 6 Entering column information

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

    Figure 7 Previewing the SQL statements for creating a table

    After the SQL statements are executed successfully, you can view the created table in the table list.

    Figure 8 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 9 User management

    Click Create User and enter user information and authorization information.

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

    For example, in the Object Permissions area, all permissions on the table (table1) in the database (test) are granted to the user (user).

    Figure 12 Previewing the SQL statements for creating a user
    Figure 13 Viewing the created user

  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 TaurusDB instance.

    Figure 14 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 15 Accessing the SQL execution window

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

    SELECT * FROM table1;

    Figure 16 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 17 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 18 Verifying the written data

Parent Topic: Connecting to a DB Instance