Logging in to a Huawei Cloud DB Instance

Precautions

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

Logging in to a DB Instance

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, 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 list
   

   

   • If the DB instance is not found, the login button is grayed out, and no operations can be performed.
   • 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 management 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 login management page, click Add Login.
   Figure 2 Adding a login
   

6. Configure login information.
   Figure 3 Configuring login information
   

   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.	-
   Collect Metadata Periodically	If this function is enabled, DAS saves only structured data, including database names, table names, and column names in the instance. Table data is not included. Metadata is collected at 00:00 every day by default. You are advised to enable Collect Metadata Periodically. If it is disabled, DAS obtains only the structured data from databases in real time, and the performance of databases is affected. The collection time cannot be customized. Once Collect Metadata Periodically is enabled, DAS collects metadata at 20:00 every day (UTC time). If you are not using the UTC time, convert the time based on your local time zone. You can also click Collect Now to collect metadata at any time you want.	Enabling Collect Metadata Periodically
   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.	Enabling Show Executed SQL Statements

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 Logins page, view login information of the new DB instance.
   Figure 4 Viewing the login information of the new DB instance
   

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

Reference

• Differences Between IAM Permissions and Database Permissions
• How Do I Use DAS to Log In to a Database Using a Read-Only Account?.