Edit instance information
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:
-
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.
-
Log on to the .
-
In the database instance list on the left, find the target instance.
-
Right-click the instance name and change the DBA or Instance Owner.
Enable or disable 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 | |
| SIT | sit | |
| UAT | uat | |
| Performance test | pet | |
| Staging | stag | |
| Production | Production | product |
| Pre-production | pre |
Steps
-
Log on to the Data Management (DMS) V5.0.
-
In the database instance list on the left, find the target instance.
-
Right-click the instance name and choose Edit.
-
In the Advanced Information section, find Environment Type and select the target type from the drop-down list.
-
Click Save.
Export instance configurations
Export instance configurations—such as Control Mode, Environment Type, and instance source—to manage instance resources offline.
For security reasons, exported configurations do not include the database account or password.
-
Log on to the .
-
In the top navigation bar, choose Data Assets > Instances.
NoteIf you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner and choose .
-
On the Instance List tab, select the target instances.
-
Choose More > Export Configuration.
Your browser downloads an Excel file named instances.
Batch edit instance information
-
Log on to the .
-
In the top navigation bar, choose Data Assets > Instances.
NoteIf you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner and choose .
-
On the Instance List tab, select the target instances and click Batch edit.
NoteAll selected instances must be of the same database type, for example, all MySQL.
-
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.