Scenarios

This topic describes how to add database login information so that you can log in to a database for visualized data management operations.

• If you have not logged in to a DB instance through the created login connection over a year, the system automatically clears all information, including the saved password, of this login.
• You can log in to the same database either on the DAS console or using other clients. Both methods do not affect each other.
• DAS allows you to manage DB instances of different types of engines. An RDS MySQL DB instance is used as an example to describe how to log in to a database.

Adding RDS DB Instance Login Information

1. On the Login Management page, click Add Login.
2. On the displayed page, select the DB engine, source database, and target DB instance, enter the login username, password, and remarks (optional), and enable Collect Metadata Periodically and Show Executed SQL Statements.
3. Test the connection as needed. If a message indicating that the connection failed is displayed, modify the connection according to the failure causes contained in the message.
   

   • The username and password for connecting to the database must be the database username and password.
   • The database user must have the remote login permission. RDS users have the remote permission by default. In other cases, the remote permission is not enabled. You need to apply for the required permission.
   • To delete the password, you can modify or delete the login.
   • You are advised to enable Show Executed SQL Statements. With it enabled, you can view the executed SQL statements under SQL Operations > SQL History and execute them again without entering the SQL statements.

4. Click Apply Now.

Connecting to Self-built Databases on ECSs

1. On the Login Management page, click Add Login.
2. On the displayed page, select the DB engine, source database, and target DB instance, enter the login username, password, and remarks (optional), and enable Collect Metadata Periodically and Show Executed SQL Statements.

   Test the connection as needed. If a message indicating that the connection failed is displayed, modify the connection according to the failure causes contained in the message.

   

   • Only self-built MySQL 8.0, 5.5, 5.6, and 5.7 databases on ECSs are supported. HA clusters are not supported currently.
   • Only Microsoft SQL Server 2008, 2012, 2014, 2016, and 2017 databases on ECSs are supported. HA clusters are not supported.
   • The username and password for connecting to the database must be the database username and password.
   • The port is the port of your self-built DB instance. Ensure that the security group of the ECS allows access to this port. To avoid conflicts with reserved ports, you are advised to set the port number in range 1024 to 65535.
   • To delete the password, you can modify or delete the connection.

3. Click Apply Now.

Connecting to DDS DB Instances

1. On the Login Management page, click Add Login.
2. On the displayed page, enter the database name, password, and remarks (optional), and enable the "metadata collection" and "show executed SQL statement" functions.
   Test the connection as needed. If a message indicating that the connection failed is displayed, modify the connection according to the failure causes contained in the message.

   

   • The username and password for connecting to the database must be the instance username and password.
   • To delete the password, you can modify or delete the connection.
   • For the same DB instance, the username is unique.

3. Click Apply Now.