This topic describes how to bind and unbind database accounts for a resource group in an AnalyticDB for MySQL cluster.
Prerequisites
You have created a resource group.
Background information
AnalyticDB for MySQL lets you bind different database accounts to different resource groups. You can use resource group isolation to schedule computing tasks based on priority. This protects core services from complex computing tasks and unexpected bursts. You can also classify queries and allocate resources to maximize cluster performance.
Rules
You cannot bind users to the user_default and serverless default resource groups.
A database account can be bound to only one resource group. A resource group can be bound to multiple database accounts.
If a database account is not bound to any custom resource group, it is bound to the default resource group.
Deleting a resource group or a database account automatically unbinds the account from the resource group.
Procedure
Enterprise, Basic, or Data Lakehouse Edition
Bind or unbind a database account in the console
Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. Find the cluster that you want to manage and click the cluster ID.
On the Cluster Management > Resource Management > Resource Group Management page, find the target resource group, and in the Operation column, click .
From the Username drop-down list, select a database account. Click Bind User. In the confirmation dialog box, click OK.
NoteYou can bind only one database account at a time. To bind multiple accounts, repeat this step.
If the drop-down list is empty, you have not created any database accounts. Create an account first. For more information, see Create a database account.
To unbind a database account, click Disassociate next to the target user in the Associate with Account list. In the confirmation dialog box, click OK.
Bind or unbind a database account using OpenAPI
Data Warehouse Edition
Bind or unbind a database account in the console
Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. Find the cluster that you want to manage and click the cluster ID.
In the navigation pane on the left, click Resource Group Management.
On the Resource Management page, find the target resource group and click Associate with Account in the Operation column.
NoteThe term "user" on the Resource Management page refers to a database account.
From the Username drop-down list, select a database account. Click Bind User. In the confirmation dialog box, click OK.
NoteYou can bind only one database account at a time. To bind multiple accounts, repeat this step.
If the drop-down list is empty, you have not created any database accounts. Create an account first. For more information, see Create a database account.
To unbind a database account, click Disassociate next to the target user in the Associate with Account list. In the confirmation dialog box, click OK.