All Products
Search
Document Center

ApsaraDB for MyBase:Create a database account

Last Updated:Jul 14, 2023

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

Prerequisites

An instance is created in an ApsaraDB for MyBase dedicated cluster. 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 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 pane, click Instances. On the page that appears, find the instance that you want to manage and click the instance name.

  5. In the left-side navigation pane, click Accounts. On the page that appears, click Create Account.

    d
  6. In the Create Account panel, configure the parameters described in the following table and click Create.

    Parameter

    Description

    Database Account

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

    • If the instance runs MySQL 5.6 or PostgreSQL, the name is 2 to 16 characters in length. If the instance runs MySQL 5.7 or MySQL 8.0, the name is 2 to 32 characters in length. If the instance runs SQL Server, the name is 2 to 64 characters in length.

    • The name starts with a lowercase letter and ends with a lowercase letter or a digit.

    • The name can contain lowercase letters, digits, and underscores (_).

    • The name is unique.

    Account Type

    • Privileged Account: The account has all permissions on all databases.

    • Standard Account: The account has all permissions on the authorized databases.

    • System Admin Account: The account has the highest management permissions on your on-premises Windows server that runs an ApsaraDB 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

      This account is supported only for ApsaraDB MyBase for SQL Server instances.

    Note

    For more information about the account permissions on instances that run MySQL, see Account permissions.

    Password

    Enter the password of the account. The password must meet the following requirements:

    • The password is 8 to 32 characters in length.

    • The password contains at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters.

    • The password can contain the following special characters: ! @ # $ % ^ & * ( ) _ + - =

    Note

    If your instance runs MySQL 5.7, you can configure a custom account password policy. For more information, see Custom password policies.

    Confirm Password

    Enter the password for 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.

References