Manage database accounts

Updated at:
Copy as MD

This topic describes how to change passwords, lock, unlock, and delete database accounts.

Background

PolarDB supports two types of database accounts: privileged accounts and standard accounts. You can manage all accounts in the PolarDB console.

Create a database account

For more information, see Create a database account.

Change password

  1. Log on to the PolarDB console.

  2. In the upper-left corner of the console, select the region of your cluster.

  3. Find the target cluster and click the cluster ID.

  4. In the navigation pane, choose Configuration and Management > Accounts.

  5. Find the target account and click Change Password in the Change Password column.

  6. In the dialog box that appears, enter the new password in the New Password field, re-enter it in the Confirm New Password field, and then click OK.

Lock account

You can lock an account to prevent it from logging in to the database.

  1. Log on to the PolarDB console.

  2. In the upper-left corner of the console, select the region of your cluster.

  3. Find the target cluster and click the cluster ID.

  4. In the navigation pane, choose Configuration and Management > Accounts.

  5. Find the target account and click the slider in the Lock Status column.

Unlock account

  1. Log on to the PolarDB console.

  2. In the upper-left corner of the console, select the region of your cluster.

  3. Find the target cluster and click the cluster ID.

  4. In the navigation pane, choose Configuration and Management > Accounts.

  5. Find the target account and click the slider in the Lock Status column.

Delete account

  1. Log on to the PolarDB console.

  2. In the upper-left corner of the console, select the region of your cluster.

  3. Find the target cluster and click the cluster ID.

  4. In the navigation pane, choose Configuration and Management > Accounts.

  5. Find the target account and click Delete in the Delete column.

  6. In the confirmation dialog box that appears, click OK.

API reference

API

Description

CreateAccount

Creates a database account.

DescribeAccounts

Returns a list of all database accounts in a cluster.

ModifyAccountDescription

Modifies the description of a database account.

ModifyAccountPassword

Changes the password of a database account.

DeleteAccount

Deletes a database account.