All Products
Search
Document Center

ApsaraDB RDS:Create accounts and databases

Last Updated:Sep 07, 2023

This topic describes how to create databases and accounts for an ApsaraDB RDS for MySQL instance.

Create a database

  1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
  2. In the left-side navigation pane, click Databases.

  3. On the page that appears, click Create Database.

  4. Configure the following parameters.

    Parameter

    Description

    Database Name

    • The name of the database. The name must be 2 to 64 characters in length.

    • The name must start with a lowercase letter and end with a lowercase letter or a digit.

    • The name can contain lowercase letters, digits, underscores (_), and hyphens (-).

    • The name must be unique within the RDS instance.

    Note

    If the database name contains a hyphen (-), the system parses the hyphen (-) as @002d in the name of the folder in which the database resides.

    Supported Character Set

    The character set of the database.

    Description

    The description of the database. The description must be 2 to 256 characters in length.

  5. Click Create.

Create an account

  1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
  2. In the left-side navigation pane, choose Accounts.

  3. On the page that appears, click Create Account.

    Note

    If the username of the account is duplicate or an account creation task is in progress, an error message may be displayed. If the error message is displayed, check whether the username of the account is duplicate or an account creation task is in progress.

  4. Configure the Database Account parameter.

    • The name of an account must start with a lowercase letter and end with a lowercase letter or a digit.

    • The name can contain lowercase letters, digits, and underscores (_).

    • The name must be 2 to 32 characters in length.

  5. Configure the Account Type parameter.

    • Standard Account: Select databases from the Unauthorized Databases section, click the 图标 icon to add the selected databases to the Authorized Databases section, and then grant the Read/Write (DDL + DML), Read-only, DDL Only, or DML Only permissions to the account.

    • Privileged Account: The privileged account has permissions on all databases that are created on the RDS instance. You do not need to grant permissions on specific databases to the privileged account.

    Note
    • For more information about the differences between privileged accounts and standard accounts, see Account types.

    • If the Privileged Account option is dimmed, a privileged account has been created on the RDS instance.

  6. Enter the password:

    • The password of the account. The password must be 8 to 32 characters in length.

    • The password must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters. The password can contain the following special characters: ! @ # $ % ^ & * ( ) _ + - =

  7. Click OK.

FAQ

Related operations

Operation

Description

CreateAccount

Creates or manages accounts.

CreateDatabase

Creates a database on an instance.

ResetAccountPassword

Resets the password of an account.

DeleteAccount

Deletes an account from an instance.

DeleteDatabase

Deletes a database from an instance.

ModifyDBDescription

Modifies the description of a database.

References