account type

The cloud database instance supports two types of database accounts: high authority accounts and ordinary accounts. You can manage all accounts and databases on the console. Please refer to the account permission list at the end of the document for the specific permissions of the account.

Difference between advanced account permissions and Super permissions

In order to reduce the impact of misoperation on business, MySQL does not provide Super permission, but can only manage all common accounts and databases with high permission accounts. The specific differences are as follows:

Create Database

1. Log in to the console ->ApsaraDB ->Manage ApsaraDB instances.

2. Find the target instance that needs to create a database account, and click Manage.

3. On the database details page, click Database Management

4. On the database management page, click Create Database

5. Enter the database name, select the appropriate character set, and click OK

Character sets supported by MySQL service

• utf8
• gbk
• latin1
• utf8mb4

Create account

1. Click Account Management

2. Click Create Account

3. Enter the database account information and click OK.

Parameter description:

• Account name: consists of lowercase letters, numbers, and underscores. It starts with a letter and ends with a letter or number. The maximum length is 16 characters
• account type
• Advanced account
• Ordinary account

• Passwords: uppercase, lowercase, numbers and special characters, 8-32 digits in length; Special characters are! @ # $%^&* ()_+-=

Create a high authority account as shown in the following figure:

Create a common account as shown in the following figure:

If the first account created is a normal account, you need to grant the account permission to connect to the cloud database instance. If you have a high permission account, you can directly connect to the cloud database instance.

After initialization and setting, refer to Connect MySQL database instance to cloud database instance.

Account permission list