Help Center > > User Guide> Console> Adding a Login

Adding a Login

Updated at:May 14, 2020 GMT+08:00

Scenarios

DAS supports the data and structure management of RDS databases, DDS databases, self-built databases on ECSs. With DAS, you can create logins to manage these databases using a GUI.

If you have not used an account for login over a year, DAS automatically clears all the information of this login, including the password remembered.

Prerequisites

You have logged in to the DAS console.

Connecting to RDS DB Instances

  1. On the Login Management page, click Add Login.
  2. On the displayed page, select the database type, source database, and target DB instance, enter the login username, password, and remarks (optional), and enable the "collect metadata" and "show executed SQL statement" functions.

    You can click Test Connection (optional) as required.
    • If a message is displayed indicating that the connection is successful, you can continue the operation.
    • If a message is displayed indicating that the connection failed and the failure causes, you need to modify the connection according to the error 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.

  3. 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 database type, source database, and target DB instance, enter the port, login username, password, and remarks (optional), and enable the "metadata collection" and "show executed SQL statement" functions.

    You can click Test Connection (optional) as required.
    • If a message is displayed indicating that the connection is successful, you can continue the operation.
    • If a message is displayed indicating that the connection failed and the failure causes, you need to modify the connection according to the error message.
    • Only MySQL 8.0, 5.5, 5.6, and 5.7 databases on ECSs are supported. HA clusters are not supported.
    • 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.

    You can click Test Connection (optional) as required.
    • If a message is displayed indicating that the connection is successful, you can continue to create the connection.
    • If a message is displayed indicating that the connection failed and the failure causes, you need to modify the connection according to the error message.
    • The username and password for connecting to the database must be the database 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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel