ApsaraDB for MyBase:Create a host account

You can use one of the following methods to create a host account:

• Create a host account on the Associate with Bastion Host page

• Create a host account on the host details page

Create a host account on the Associate with Bastion Host page

Prerequisites

• The database engine of your ApsaraDB for MyBase dedicated cluster is MySQL, SQL Server, or PostgreSQL.

• OS permissions are granted when the ApsaraDB for MyBase dedicated cluster is created. For more information, see Create a dedicated cluster.

• A bastion host is created. For more information, see Create a bastion host.

1. Log on to the Bastionhost console. Find the bastion host that you want to manage and click Run on the right side to enable the bastion host. For more information, see Enable a bastion host.

   

2. Associate an ApsaraDB for MyBase host with the bastion host.

   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 Bastion Hosts. On the page that appears, find the bastion host that you want to manage and click Associate with Bastion Host in the Actions column.

   5. Click Import Host. In the dialog box that appears, select the host that you want to import and click Import.

3. Create a host account.

   1. Find the ApsaraDB for MyBase host and click Add an account in the Host Account column.

   2. In the Create Host Account dialog box, configure the parameters described in the following table.

      

      Parameter	Description
      Username	The username of the account. The username must start with a lowercase letter and end with a lowercase letter or a digit. The username can contain lowercase letters, digits, and underscores (_). The username must be 2 to 16 characters in length. The username cannot be root, admin, or another username that is reserved by the system.
      Account Type	The type of the account. If the database engine of your dedicated cluster is SQL Server, you can select one of the following account types: Standard Account Administrator Note For more information about host permissions, see Host permissions.
      Password	The password of the account. The password must meet the following requirements: The password must be 6 to 32 characters in length. The password must contain 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 the database engine of your dedicated cluster is SQL Server, the password cannot contain the account name (case-insensitive).

   3. Click Create.

      Note

      After you create a host account, you can edit or delete the host account in the Bastionhost console. For more information about how to edit or delete a host account, see Configure account information for a host.

Create a host account on the host details page

Prerequisites

• OS permissions are granted when your ApsaraDB for MyBase dedicated cluster is created. For more information, see Create a dedicated cluster.

• The database engine of your ApsaraDB for MyBase dedicated cluster is SQL Server.

1. Log on to the ApsaraDB for MyBase console.

2. In the upper-left corner of the page, select a region.

3. In the left-side navigation pane, click Hosts.

4. On the page that appears, find the ApsaraDB for MyBase host that you want to manage and click Details in the Actions column.

5. On the Host Information tab, click Create and configure the parameters described in the following table.

   Parameter	Description
   Username	The username of the account. The username must meet the following requirements: The username can contain lowercase letters, digits, and underscores (_). The username must start with a lowercase letter and end with a lowercase letter or a digit. The username must be 2 to 16 characters in length. The username cannot be root, admin, test, or another username that is reserved by the system.
   Account Type	The type of the account. Note For more information about host permissions, see Host permissions.
   Password	The password of the account. The password must meet the following requirements: The password must be 8 to 32 characters in length. The password must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters. The password cannot contain the account name (case-insensitive). The password can contain the following special characters: ! @ # $ % ^ & * ( ) _ + - =

6. Click Create.

   Note

   After you create a host account, you can edit or delete the host account on the Host Information tab. For more information, see Manage a host account.

Related operations