This topic describes how to create an account for a database instance in an ApsaraDB for MyBase dedicated cluster.

Prerequisites

A database instance in an ApsaraDB for MyBase dedicated cluster is created. MySQL, SQL Server, or PostgreSQL is selected as the engine of the dedicated cluster.

Procedure

  1. Log on to the ApsaraDB for MyBase console.
  2. In the upper-left corner of the page, select the region where you want to deploy the dedicated cluster.
    Select a region
  3. Find the dedicated cluster that you want to manage and click Details in the Actions column.
  4. In the left-side navigation tree, click Instances. On the page that appears, find the instance for which you want to create an account and click the instance name.
  5. In the left-side navigation pane, click Accounts. On the page that appears, click Create Account.
  6. In the Create Account panel, configure the parameters and click Create.
    Parameter Description
    Database Account

    Enter an account name. The name must meet the following requirements:

    • If the database uses the MySQL 5.6 or PostgreSQL engine, the name must be 2 to 16 characters in length. If the database uses the MySQL 5.7 or MySQL 8.0 engine, the name must be 2 to 32 characters in length. If the database uses the SQL Server engine, the name must be 2 to 64 characters in length.
    • The name must start with a letter and end with a letter or a digit.
    • The name can contain lowercase letters, digits, and underscores (_).
    • The name cannot be the same as that of an existing account.
    Account Type
    • Privileged Account: The account has all permissions on all databases.
    • Standard Account: The account has all permissions on the databases that it is authorized to manage.
    • System Admin Account: The account has the highest management permissions on your on-premises Windows server that runs a MyBase for SQL Server instance. If you use such an account to manage your instance, a service level agreement (SLA) for ApsaraDB for MyBase cannot be guaranteed.
    Note For more information about the account permissions on databases that use the MySQL engine, see Account permissions on databases that use the MySQL engine.
    Password

    Enter a password for the account. The password must meet the following requirements:

    • It must be 8 to 32 characters in length.
    • It must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters.
    • It can contain the following special characters: !@#$%^&*()_+-=
    Note If your database instance runs the MySQL 5.7 engine, you can configure a custom account password policy. For more information, see Configure a custom password policy.
    Confirm Password Enter the password of the account again.
    Description Enter a description that is used to identify the account for future management. The description can be up to 256 characters in length.