This topic describes how to create an account that is used to manage the databases of an ApsaraDB RDS for MySQL instance.
Prerequisites
Create an ApsaraDB RDS for MySQL instance
Account types
ApsaraDB RDS for MySQL supports two types of accounts: privileged accounts and standard accounts. You can manage all the accounts and databases of your RDS instance by using the ApsaraDB RDS console. For more information about the permissions that can be granted to each type of account, see Account permissions.Account type | Description |
---|---|
Privileged account |
|
Standard account |
|
Account type | Maximum number of databases | Maximum number of tables | Maximum number of accounts |
---|---|---|---|
Privileged account | Unlimited | < 200,000 | Varies based on the minor engine version. |
Standard account | 500 | < 200,000 | Varies based on the minor engine version. |
Create a privileged account
Reset the permissions of a privileged account
If the privileged account of your RDS instance encounters exceptions, for example, the permissions are accidentally revoked, you can perform the following steps to reset the permissions:
- Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
- In the left-side navigation pane, click Accounts.
- Find the account whose Account Type is Privileged Account. Then, click Reset Permissions in the Actions column.
- In the dialog box that appears, enter the password of the privileged account and click OK.
Create a standard account
FAQ
- Can I configure an account to have only the permissions to access my RDS instance
over an internal network?
Yes, you can use SQL statements to specify the source IP address from which an account can access your RDS instance. For more information, see Authorize an account to access its authorized databases from specified IP addresses in an ApsaraDB RDS for MySQL instance. However, this operation is not supported in the ApsaraDB RDS console.
- Can I configure the permissions of an account at finer-grained levels, such as the
table level?
Yes, you can use SQL statements to manage the permissions of an account at finer-grained levels. For more information, see Authorize accounts to manage tables, views, and fields. However, this operation is not supported in the ApsaraDB RDS console.
Related operations
Operation | Description |
---|---|
CreateAccount | Creates an account that is used to manage the databases of an ApsaraDB RDS instance. |