Docs

Database Workshop

Database management

This topic describes how to visually create, edit, and delete databases on the Database Workshop (DBW) console to manage the entire lifecycle of databases.

Prerequisites

You have created an instance and created an account.

tip

The account you create must have the corresponding permissions for querying and modifying the corresponding database.

Precautions

Deleting and editing system databases is not supported.

It is not recommended to perform operations such as adding, deleting, or modifying tables, views, triggers, and stored procedures in the system database.

The creation, deletion, and other operations you perform may affect the online business operation. It is recommended to perform them during off-peak hours.

Create a database

Log on to the data interaction platform for veDB for MySQL.

On the top menu bar of the Data interaction platform page, click the icon next to the database and select the target database.

Click Create database.

In the Create database dialog box, configure the following parameters.

Parameter	Description
Database name	Custom database name. Naming rules are as follows: The database name must be unique within the instance. The length is 2 to 64 characters, and can not be empty. The name must start with a letter and end with a letter or a digit. It consists of lowercase letters, numbers, underscores (_), or hyphens (-). Database names can not be keywords.
Character set	From the drop-down list, select the character set. tip MySQL 5.7 supports latin1, ascii, utf8, and utf8mb4 formats. MySQL 8.0 supports latin1, ascii, utf8mb3, and utf8mb4 formats.
Sorting rules	After you select a character set, the default sorting rule is displayed. If you have other requirements, you can configure it as needed.

Click OK.

Edit a database

tip

Editing system databases is not supported.

Log on to the data interaction platform for veDB for MySQL.

On the top menu bar of the Data interaction platform page, click the icon next to the database and select the target database.

Click Database management.

On the Database management tab, click Edit in the Actions column of the target database.

In the Edit database dialog box, edit the database Character set and Sorting rules.

Click OK.

Delete a database

tip

Deleting system databases is not supported.

Log on to the data interaction platform for RDS for MySQL.

On the top menu bar of the Data interaction platform page, click the icon next to the database and select the target database.

Click Database management.

On the Database management tab, click Delete in the Actions column of the target database.

In the Confirm deletion dialog box, enter the database name in the deletion confirmation input box.

Click OK.

Related APIs

API	Description
DataExecCommands	Call the DataExecCommands interface to execute an SQL command.
DataSessionKeepAlive	Call the DataSessionKeepAlive API to keep an SQL session alive.
DataCloseSession	Call the DataCloseSession interface to close an SQL session.
DataCancelExec	Call the DataCancelExec interface to cancel SQL execution.

Last updated: 2026.04.30 11:46:51