Create a database account

Limitations

You can create up to 500 database accounts for a single ApsaraDB for ClickHouse cluster.

Prerequisites

The ApsaraDB for ClickHouse cluster must be in the Running state. For instructions, see Create a cluster.

Procedure

1. Log on to the ApsaraDB for ClickHouse console.

2. In the upper-left corner, select your cluster's region.

3. On the Clusters page, go to the Instance list tab and click your target cluster's ID.

4. In the left-side navigation pane, click Account Management.

5. In the upper-right corner, click Create Account.

6. Configure the following parameters. This example creates a database account named test.

   Parameter	Description	Example
   Database account	The account name. It must meet the following requirements: Must be unique within the cluster. Must consist of lowercase letters, digits, and underscores (_). Must start with a lowercase letter and end with a lowercase letter or a digit. Must be 2 to 64 characters long.	test
   Account type	The type of the database account. Valid values: Privileged Account Standard Account Note By default, a standard account has only connection permissions. To perform operations on databases or tables, use a privileged account to grant the required permissions. For more information, see GRANT.	Privileged Account
   Password	The account password. It must meet the following requirements: Must contain characters from at least three of the following categories: uppercase letters, lowercase letters, digits, and special characters. Special characters include: !@#$%^&*()_+-= Must be 8 to 32 characters long.	123456Aa
   Confirm password	Enter the password again to confirm.	123456Aa
   Description	An optional description for the account. It must meet the following requirements: Must be 0 to 256 characters long. Cannot start with http:// or https://.	Test account

7. Click OK.

   After you create the account, you can view it on the Account Management page.

Next steps

Configure a whitelist