Help Center/ Data Admin Service/ User Guide/ Logging in to a DB Instance/ Logging in to a Huawei Cloud DB Instance
Updated on 2024-11-28 GMT+08:00

Logging in to a Huawei Cloud DB Instance

This section describes how to log in to a Huawei Cloud DB instance on DAS.

After a Huawei Cloud DB instance is created, DAS automatically creates login information for an administrator.

If you want to use a non-administrator account to log in to the DB instance, you need to create a DB instance login first. For details, see Configuring Login Information.

Precautions

  • RDS for MySQL, RDS for PostgreSQL, RDS for SQL Server, RDS for MariaDB, DDS, TaurusDB, GaussDB, and GeminiDB Cassandra instances are supported.
  • The created DB instance and DAS must be in the same region.

Logging in to a DB Instance

  1. Log in to the DAS console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the target DB instance and click Log In in the Operation column.

    You need to enter the password at the first login. If Remember Password is selected at the first login, you do not need to enter the password again at subsequent logins.
    Figure 1 Database login information
    • If a DB instance is not found, its Log In button will be grayed out.
    • If the pop-up window is blocked when you click Log In, configure your browser to allow the Huawei Cloud website. After that, you can log in to the instance.
    • The DB Instance Logins that IAM Users Share with Others tab page is displayed only when the Huawei ID account is used for login.

Configuring Login Information

  1. Log in to the DAS console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. On the My DB Instance Connections tab page, click Add DB Instance Connection.

    Figure 2 Adding a DB instance connection

  6. Configure parameters for the new DB instance connection.

    Figure 3 Configuring parameters for the new DB instance connection
    Table 1 Description

    Parameter

    Description

    Example Value

    DB Engine

    DB engine for the instance that you want to add login information for.

    MySQL

    Source Database

    The source database depends on the DB engine that you select.

    After you select a source database, all instances of the current type under your account are displayed. You can select the instance that you want to add a login for.

    The following types of source databases are supported:

    • RDS
    • DDS
    • DDM
    • GaussDB
    • GeminiDB
    • DWS
    • MariaDB

    RDS

    Login Username

    Username for logging in to the selected DB instance.

    The user must have the permission to allow DAS to access the selected DB instance using an IP address.

    root

    Password

    Password for logging in to the selected DB instance.

    You can select Remember Password. With this function enabled, you do not need to enter the password when you want to log in to the DB instance later.

    -

    Description

    This parameter is optional.

    -

    Show Executed SQL Statements

    If this function is enabled, all the SQL statements executed in the SQL window will be saved.

    You are advised to enable Show Executed SQL Statements. With it enabled, you can choose SQL Operations > SQL History to see what SQL statements you have executed and can re-execute any executed SQL statements rather than entering them again.

    Enabled

  7. After the DB instance information is configured, click Test Connection on the right of the password text box.

    • If the connection test is successful, go to 8.
    • If a message is displayed indicating a connection test failure and failure causes, modify DB instance information based on the message and then go to 8.

  8. After the connection test is successful, click OK.
  9. On the My DB Instance Connections tab page, view information about the new DB instance connection.

    Figure 4 Viewing information about the new DB instance connection

    You can also click Modify in the Operation column to modify the instance login information, or click Delete to delete unnecessary instance login information.