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

Create a database

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, click Databases.
  3. Click Create Database.
  4. Configure the following parameters.
    Parameter Description
    Database Name
    • The name must be 2 to 64 characters in length.
    • The name of a database 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.
    Supported Character Set Select the character set that is supported by 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. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, click Accounts.
  3. Click Create Account.
  4. In the Database Account field, enter the username of the account.
    • 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. Specify the Account Type parameter.
    • Standard Account: Select databases from the Unauthorized Databases section, click the Icon 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. In the Password field, enter 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 any of the following characters: ! @ # $ % ^ & * ( ) _ + - =
  7. Click OK.

FAQ

References