This topic describes how to create an account that is used to manage the databases of an ApsaraDB RDS for MariaDB instance.
Account types
Account type | Description |
---|---|
Privileged account |
|
Standard account |
|
Create a privileged account
- Log on to the ApsaraDB RDS console.
- In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.
- Find your RDS instance and click its ID.
- In the left-side navigation pane, click Accounts.
- Click Create Account.
- In the Create Account panel, configure the following parameters.
Parameter Description Database Account Enter the username of the account. The username must meet the following requirements:
- The username must be 2 to 16 characters in length.
- The username must start with a letter and end with a letter or digit.
- The username can contain lowercase letters, digits, and underscores (_).
- The username cannot be the same as that of an existing account.
Note If the username of the privileged account is the same as that of an existing standard account, the privileged account replaces the standard account.Account Type Specify the type of the account. For this example, select Privileged Account. Password Enter the password of the account. The password must meet the following requirements:
- 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.
- Special characters include: ! @ # $ % ^ & * ( ) _ + - =
Confirm Password Enter the password of the account again. Description Enter a description that helps identify the account. The description can be up to 256 characters in length. - Click OK.
Reset the permissions of a privileged account
If the permissions of a privileged account are accidentally revoked or encounter other exceptions, perform the following steps to reset the permissions:
- Log on to the ApsaraDB RDS console.
- In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.
- Find your RDS instance and click its ID.
- In the left-side navigation pane, click Accounts.
- Find the privileged account and click Reset Permissions in the Actions column.
- In the dialog box that appears, specify a new password and click OK.
Create a standard account
- Log on to the ApsaraDB RDS console.
- In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.
- Find your RDS instance and click its ID.
- In the left-side navigation pane, click Accounts.
- Click Create Account.
- In the Create Account panel, configure the following parameters.
Parameter Description Database Account Enter the username of the account. The username must meet the following requirements:
- The username must be 2 to 16 characters in length.
- The username must start with a letter and end with a letter or digit.
- The username can contain lowercase letters, digits, and underscores (_).
Account Type Specify the type of the account. For this example, select Standard Account. Authorized Databases Specify the authorized databases of the account. You can specify one or more authorized databases. You can also leave this parameter empty. This is because you can grant the permissions on specific databases to the account after the account is created. - Select one or more databases from the Unauthorized Databases section and click the rightwards arrow to add the selected databases to the Authorized Databases section.
- In the Authorized Databases section, select the Read/Write (DDL + DML), Read-only, DDL Only, or DML Only permissions for each authorized database.
If you want to grant the same permissions on multiple authorized database at a time, select the authorized databases and click the button in the upper-right corner. For example, click Set All to Read/Write (DDL + DML).
Note The button in the upper-right corner changes after you click it. For example, after you click Set All to Read/Write, the button changes to Set All to Read-only.
Password Enter the password of the account. The password must meet the following requirements:
- 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.
- Special characters include: ! @ # $ % ^ & * ( ) _ + - =
Confirm Password Enter the password of the account again. Description Optional. Enter a description that helps identify the account. The description can be up to 256 characters in length. - Click OK.
Related operations
Operation | Description |
---|---|
CreateAccount | Creates an account that is used to manage the databases of an ApsaraDB RDS instance. |