Help Center/ Data Admin Service/ User Guide/ Logging in to a DB Instance/ Logging In to a Database Built On Huawei Cloud ECSs/ Step 1: Adding DB Instance Login Information
Updated on 2025-01-17 GMT+08:00
View PDF
Share

Step 1: Adding DB Instance Login Information

Before logging in to a DB instance built on a Huawei Cloud ECS, you need to add a DB instance login. A created DB instance login can be modified or deleted.

Usage Notes

  • If you have not logged in to a DB instance using a created login for over a year, the system will automatically delete all data of the login, including the saved password.
  • You can log in to a DB instance either on the DAS console or using other clients. These two methods do not affect each other.

Adding Login Information

  1. Log in to the Huawei Cloud 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. Click Add DB Instance Connection.

    Figure 1 Adding a DB instance connection

  6. Configure parameters for the new DB instance connection.

    Figure 2 Configuring parameters for the new DB instance connection
    Table 1 Parameter description

    Parameter

    Description

    Example Value

    DB Engine

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

    MySQL

    Source Database

    The following types of databases are supported:

    • MySQL 5.5, 5.6, 5.7, and 8.0 instances.
    • PostgreSQL 9.4, 9.5, 9.6, 10, 11 and 12 instances.
    • SQL Server 2008, 2012, 2014, 2016, and 2017 instances are supported. HA clusters are not supported.

    ECS

    Port

    When Source Database is set to ECS, you need to enter a port number for the instance that you select.

    Ensure that the security group of the ECS allows access to this port. To avoid conflicts with reserved ports, you are advised to enter a port number ranging from 1024 to 65535.

    3306

    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.

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