Create a database account

MySQL, SQL Server, and PostgreSQL

1. Log in to the ApsaraDB for MyBase console.
   
2. In the upper-left corner of the page, select the target region.
   
3. In the Actions column of the target dedicated cluster, click Details.
4. In the left-side navigation pane, click Instances, and then click the target instance.
5. In the left-side navigation pane, click Accounts, and then click Create Account.
6. In the Create Account dialog box, set the following parameters and click Create.

   Parameter	Description
   Database account	Enter a name for the account. The name must meet the following requirements: Must be 2 to 16 characters for MySQL 5.6 and PostgreSQL, 2 to 32 for MySQL 5.7 and 8.0, and 2 to 64 for SQL Server. Must start with a lowercase letter and end with a lowercase letter or a digit. Must contain only lowercase letters, digits, and underscores (_). Must be unique within the instance.
   Account type	Privileged Account: Has all operational permissions on all databases. Standard Account: Has all operational permissions on the authorized databases. System Admin Account: Has the highest administrative permissions of the local Windows group for SQL Server. If you enable this option, the Service Level Agreement (SLA) for the instance is no longer guaranteed. Note This account type is supported only for ApsaraDB for MyBase for SQL Server instances. Note For more information about MySQL account permissions, see MySQL account permission list.
   Password	Set the password for the account. The password must meet the following requirements: Must be 8 to 32 characters in length. Must contain characters from at least three of the following categories: uppercase letters, lowercase letters, digits, and special characters. Allowed special characters are !@#$%^&*()_+-=. Note You can customize the password policy for MySQL 5.7 instances. For more information, see Customize password policies.
   Confirm password	Enter the password again.
   Description	Enter a description for the account to aid future management. The description can be up to 256 characters long.

Redis

For more information about creating a management account for a Redis instance, see Create and manage accounts.

Related topics

• Create a database account for an ApsaraDB for MyBase for MySQL instance
• Create a database account for an ApsaraDB for MyBase for SQL Server instance
• Create a database account for an ApsaraDB for MyBase for PostgreSQL instance