Prerequisites
You have viewing or higher permissions to the instance.
Procedure
1. Log in to DMS.
2. On the left menu bar, click Data Source Management > Instance Metadata to go to the Instance List page.
3. Go to the Operate menu bar of the target instance and click the Database List button to go to the database management page.
4. Click the Synchronize Metadata button to obtain the real-time metadata information of the database.
Introduction to the Database Management Function
Functional Item | Description |
Create Database | Allows you to create a database and synchronize the database metadata for the current instance. |
Database Search | Allows you to search for the database under the current instance. A fuzzy search by database name is supported. |
Database Switch | Displays the basic information about the current instance. You can switch instances using the dropdown box and display the database list of different instances. |
Database List | Displays the information about the database, including the database name, character set, sorting rules, and more. The list information varies between different databases. |
Database Operation | Allows you to navigate to the list page of the subordinate objects, navigate to the query window page, and delete databases. |
MySQL Database Management
The database type is the MySQL series.
Creating a Database
1. Log in to DMS.
2. On the Instance List page, click the Database List button to go to the Database Management page.
3. Click the Create Database button and enter the optional parameters as required.
4. Click the OK button to finish creating the database.
Parameter Description of Creating a Database
Parameter | Mandatory or Not | Description |
Database Name | Yes | The name of the database after creation. |
Authorize Account Permission | No | Grants the current database permissions to the specified user. |
Character Set | No | The character set of the database, which defaults to utf8mb4. |
Sorting Rule | No | The sorting rule for the database, which defaults to utf8mb4_0900_ai_ci. |
Deleting a Database
Go to the Operate menu of the database list and click the Delete button. After re-confirmation, finish deleting the target database.
PostgreSQL Data Management
The database type is the PostgreSQL series.
Creating a Database
1. Log in to DMS.
2. On the Instance List page, click the Database List button to go to the Database Management page.
3. Click the Create Database button and enter the optional parameters as required.
4. Click the OK button to finish creating the database.
Parameter Description of Creating a Database:
Parameter | Mandatory or Not | Description |
Database Name | Yes | The name of the database after creation. |
Authorize Account Permission | No | Grants the current database permissions to the specified user. |
Comment | No | The remarks information for the database. |
Owner | No | The owner of the database in the instance. |
Character Set | No | Defaults to UTF8. |
Example | No | Create a database based on a specified template. |
Tablespace | No | The tablespace of the specified database. |
Connection Limitation | No | The connection limitation for the current database. |
Deleting a Database
Go to the Operate menu of the database list and click the Delete button. After re-confirmation, finish deleting the target database.