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 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

• Can I manage accounts at fine-grained levels, such as the source IP address level and the table level?

  For more information, see Authorize an account to access its authorized databases from specified IP addresses in an ApsaraDB RDS for MySQL instance and Authorize accounts to manage tables, views, and fields.

• Does ApsaraDB RDS provide accounts that are equivalent to root or superuser accounts?

  No, ApsaraDB RDS does not provide accounts that are equivalent to root or superuser accounts. This way, your RDS instance can be protected from data loss and leaks that are caused by accidental operations.

References

• For more information about how to create an account for an RDS instance by calling an API operation, see Create a database account.
• For more information about how to create a database for an RDS instance by calling an API operation, see Create a database.
• For more information about how to create databases and accounts for an RDS instance that runs a different database engine, see the following topics:
  • Create an account and a database for an ApsaraDB RDS instance that runs SQL Server 2012, 2016, 2017 SE, or 2019 SE
  • Create an account and a database for an ApsaraDB RDS instance that runs SQL Server 2008 R2
  • Create databases and accounts for an ApsaraDB RDS for PostgreSQL instance
  • Create databases and accounts for an ApsaraDB RDS for MariaDB TX instance