All Products
Search

This Product

    ApsaraDB RDS:Use DMS to log on to an ApsaraDB RDS instance

    Document Center

    ApsaraDB RDS:Use DMS to log on to an ApsaraDB RDS instance

    Last Updated:Mar 01, 2026

    Data Management (DMS) provides an integrated solution for database operations, including data management, schema management, user authorization, security audit, trend analysis, data tracking, business intelligence (BI) charting, and performance analysis and optimization. Log on to an ApsaraDB RDS for MySQL instance through DMS to manage all these tasks from a single interface.

    Prerequisites

    Procedure

    1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.

    2. In the upper-right corner, click Log On to Database to open the DMS quick logon page.

    3. On the Log on to Database Instance page, select an Access mode and a Control Mode.

      Access methods

      DMS supports two access methods:

      • Account + password login: Log on with a database account that has permissions on the destination database and the account password.

        Note

        Note: To create a database account, see Create an account.

      • Logon with KMS Secret: Select an RDS credential created in Key Management Service (KMS) to log on.

        Note

        When using this access method, DMS automatically enables Security Collaboration for the instance free of charge.

        Alternatively, click Enable Security Hosting, enter the database account and password, and enable Security Collaboration free of charge for password-free logon.

      Control modes

      Select one of three instance-level control modes based on your requirements:

      • Flexible Management

      • Stable Change

      • Security Collaboration

    4. After logon, refresh the page to view the instance and its databases in the Instances Connected list on the left panel.

      Note

      If Security Collaboration is enabled, the instance appears under Logon-free Instances instead.

    Change the database account for logon

    Account + password logon

    1. In the Instances Connected list in the DMS console, right-click the instance ID or name.

    2. Select Switch account.

    3. Enter the new database account and password to log on.

    Security Collaboration logon

    1. In the Logon-free Instances list in the DMS console, right-click the instance ID or name.

    2. Select Edit.

    3. In the Edit Instance dialog box, select Security hosting for Access Method, and enter the new database account and password to log on.

    Usage notes

    • Switch databases: Double-click the destination database in the left panel. The USE command is not supported.

    • Missing database after expanding the instance: Two possible causes:

      • Insufficient permissions: The database account lacks access permissions on the destination database. Modify the account permissions on the Account page. See Modify account permissions.

      • Metadata not synced: Hover over the instance name and click the refresh button to update the database list.

    • Sync table schemas: Use the DMS empty database initialization feature to synchronize table schemas to a database.

    • Alternative logon: Instead of logging on from the RDS console, register the RDS instance directly in DMS and log on from the DMS console.

    • Password reset: After resetting the database account password, log on to DMS again.