This topic describes how to create an account that is used to manage the databases of an ApsaraDB RDS for MySQL instance.
Prerequisites
An RDS instance is created. For more information, see 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 accounts and databases of your RDS instance in the ApsaraDB for 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 database engine parameter settings. |
Standard account | 500 | < 200,000 | Varies based on the database engine parameter settings. |
Create a privileged account
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:
Create a standard account
FAQ
- Can I configure an account to grant it only the permissions to access my RDS instance
over an internal network?
This configuration is not supported in the ApsaraDB for RDS console. You can use SQL statements to specify the source IP address from which an account can access your RDS instance. For more information, see Limit permissions of a specific IP address on a database.
- Can I configure the permissions of an account at fine-grained levels, such as the
table level?
This configuration is not supported in the ApsaraDB for RDS console. You can use SQL statements to manage the permissions of an account at fine-grained levels. For more information, see Authorize accounts to manage tables, views, and fields.
Related operations
Operation | Description |
---|---|
CreateAccount | Creates an account on an ApsaraDB for RDS instance. |