All Products
Search
Document Center

Database management and user management

Last Updated: May 08, 2020

Data Management Service (DMS) provides the database management and user management features. Privileged users of Relational Database Service (RDS) databases and users of user-built MySQL databases on Elastic Compute Service (ECS) instances can create databases and users, without the need to execute SQL statements.

The following table describes the two features.

Feature Description
Database management This feature allows you to create, edit, and delete databases.
User management This feature allows you to create, edit, and delete users, and manage user permissions.

Manage databases

  1. Log on to the target RDS database or user-built database on an ECS instance.

  2. In the top navigation bar, choose Tools > Database Management.

  3. You can perform the following operations:

    • Create a database.
    • Edit a database.
      You can only modify the character set and validation rule.
    • Delete a database.

Manage users

  1. Log on to the target RDS database or user-built database on an ECS instance.
  2. In the top navigation bar, choose Tools > User Management.

  3. You can perform the following operations:

    • Create a user.
      When creating a user, you must specify the username, password, and host from which the user logs on to the database. You can also click Advanced Options, Global Permissions, and Object Permissions to specify finer-grained permissions.
    • Edit a user.
    • Delete a user.
    • Manage user permissions.