Delete a privileged or standard account from an ApsaraDB RDS for MariaDB instance when it is no longer needed.
Choose a deletion method
| Method | Privileged accounts | Standard accounts |
|---|---|---|
| ApsaraDB RDS console | Supported | Supported |
| SQL statements | Not supported | Supported |
Delete an account in the console
Use the console to delete privileged accounts and standard accounts.
Go to the Instances page. In the top navigation bar, select the region where the instance resides, then click the instance ID.
In the left-side navigation pane, click Accounts.
Find the account you want to delete and click Delete in the Actions column.
In the dialog box, click OK.
Delete a standard account using SQL
SQL statements can only delete standard accounts. To delete a privileged account, use the console.
Go to the Instances page. In the top navigation bar, select the region where the instance resides, then click the instance ID.
In the upper-right corner, click Log On to Database to open the RDS Database Logon page in the Data Management (DMS) console.
In the top navigation bar, choose .
Run the following statement:
DROP USER 'username';Click Execute.
API reference
| Operation | Description |
|---|---|
| Deletes accounts including privileged accounts and standard accounts. |