All Products
Search

This Product

    Data Management:Edit instance information

    Document Center

    Data Management:Edit instance information

    Last Updated:Mar 30, 2026

    After you register an instance in Data Management (DMS), you can edit its Instance Owner, DBA, basic information (such as the database account, Security Hosting, and Security Rules), or advanced information (such as the Environment Type, Lock-free Schema Change, and query and export timeouts).

    This page covers the following tasks:

    Prerequisites

    Before you begin, ensure that you have:

    • The Administrator or DBA system role in DMS

    Change instance owner or DBA

    Before you change ownership:

      Note

      • The new Instance Owner must be a registered DMS user. To add a user, see User Management.

      • The new DBA must be a registered DMS user with the DBA system role.

      • An instance can have multiple Instance Owners but only one DBA.

    1. Log on to the DMS console V5.0.

    2. In the database instance list on the left, find the target instance.

    3. Right-click the instance name and change the DBA or Instance Owner.

    Enable or disable Security Hosting

    See Enable Security Hosting.

    Change the environment type

    Environment types

    The Environment Type of an instance takes effect only in DMS. DMS provides eight environment types in two categories:

    Category Environment type Environment ID
    Test Development dev
    Test Test test
    Test SIT sit
    Test UAT uat
    Test Performance test pet
    Test Staging stag
    Production Production product
    Production Pre-production pre

    Steps

    1. Log on to the DMS console V5.0.

    2. In the database instance list on the left, find the target instance.

    3. Right-click the instance name and choose Edit.

    4. In the Advanced Information section, find Environment Type and select the target type from the drop-down list.

    5. Click Save.

    Export instance configurations

    Export instance configurations—such as Control Mode, Environment Type, and instance source—to manage instance resources offline.

    Note

    For security reasons, exported configurations do not include the database account or password.

    1. Log on to the DMS console V5.0.

    2. In the top navigation bar, choose Data Assets > Instances.

      Note

      If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner and choose All Features > Data Assets > Instances.

    3. On the Instance List tab, select the target instances.

    4. Choose More > Export Configuration.

    Your browser downloads an Excel file named instances.

    Batch edit instance information

    1. Log on to the DMS console V5.0.

    2. In the top navigation bar, choose Data Assets > Instances.

      Note

      If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner and choose All Features > Data Assets > Instances.

    3. On the Instance List tab, select the target instances and click Batch edit.

      Note

      All selected instances must be of the same database type, for example, all MySQL.

    4. In the dialog box, select the checkboxes for the configuration items you want to change and edit the instance information.

    FAQ

    • Why do I get an "Access denied for user 'example_user'@'%' to database 'example_db'" error when creating a database in DMS?

      The database account lacks permission to create databases. Either grant the necessary permissions in the instance console, or log on to DMS with a more privileged account. For details, see Modify account permissions.

    • Why are permissions lost after I change the IP address of a VPC-connected instance?

      DMS binds permissions to the instance ID, not the IP address. When you change the host IP to an address previously used by a deleted instance, DMS treats the change as a restoration of that deleted instance—it marks your current instance as "deleted" and reactivates the historical one. Because the reactivated instance has a different instance ID, the permissions bound to your original instance are lost.

    • Does the DMS instance ID change after I modify the IP address of a VPC-connected instance?

      It depends on whether the new IP address has a history in DMS:

      • New IP address with no prior history in DMS: DMS updates the IP address for the current instance. The instance ID and permissions remain unchanged.

      • New IP address previously used by a deleted instance: DMS restores the historical instance and deletes the current one. The active instance ID changes to that of the historical instance, and the original permissions are lost.