Creating a Database Account

Scenarios

When you create a TaurusDB instance, account root is created at the same time by default. You can create other database accounts as needed.

Constraints

This operation is not allowed when another operation is being performed on your DB instance.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page, choose Database > TaurusDB.
4. On the Instances page, click the instance name to go to the Basic Information page.
5. In the navigation pane, choose Accounts. On the displayed page, click Create Account. In the displayed dialog box, enter a username, authorize permissions for databases, enter a password, and confirm the password. Then, click OK.

   Table 1 Parameter description

   Parameter	Description
   Username	The username can consist of 1 to 32 characters. Only letters, digits, and underscores (_) are allowed.
   Host IP Address	To enable all IP addresses to access your DB instance, enter % for Host IP Address. To enable all IP addresses in the subnet 10.10.10.* to access your DB instance, enter 10.10.10.% for Host IP Address. To specify multiple IP addresses, separate them with commas (,), for example, 192.168.0.*,172.16.213.* (no spaces before or after the comma).
   Database	You can select one or more unauthorized databases and authorize their permissions to the account. If there are no unauthorized databases, you can create ones. You can also modify the database permissions after the account is created. NOTE: If you delete a database somewhere other than on the TaurusDB console, permissions granted specifically for the database are not automatically deleted. They must be deleted manually. This is an open-source MySQL behavior. For details, see DROP DATABASE Statement.
   Password	The password must: Consist of 8 to 32 characters. Contain at least three types of the following characters: uppercase letters, lowercase letters, digits, and special characters (~!@#$%^*-_=+?,()&|.). Comply with the values of validate_password parameters. To check the password-related parameters, click the instance name, choose Parameters in the navigation pane, and search for validate_password in the upper right corner of the page. Be different from the username or the username spelled backwards.
   Confirm Password	The value must be the same as that of Password.
   Remarks	The remarks can consist of up to 512 characters. It cannot contain carriage returns or any of the following special characters: !<"='>&

6. After the account is created, manage it on the Accounts page.

Creating a Database Account Through DAS

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page, choose Database > TaurusDB.
4. On the displayed login page, enter the username and password and click Log In.
5. Choose SQL Operations > SQL Query and enter the following command:

   create user Account name;