tencent cloud

This document describes how to create a database and manage database account permissions on the Database Management tab in the TDSQL-C for MySQL console.

Directions

1. Log in to the TDSQL-C for MySQL console and click the ID of the target cluster in the cluster list or Manage in the Operation column to enter the cluster management page.
2. On the cluster management page, select the Database Management page and click Create Database.
   
3. In the pop-up window, configure the following parameters and click OK:
   

   Parameter	Description
   Database Name	Enter the database name, which can contain up to 64 lowercase letters, digits, hyphens, and underscores and must start with a letter and end with a letter or digit.
   Character Set	Set the character set supported by the database. For more information, see MySQL documentation.
   Sorting Rule	Set the sorting rule of the database. For more information, see MySQL documentation.
   Authorize User	Click Add and select the account to be authorized, permissions to be granted, and host information. You can also delete the authorization record.
   Remarks	Enter remarks for the database, which can contain up to 256 characters.

Account authorization details

You can grant an account the read-only, read-write, DML, DDL, and read-only & index permissions of the created database. The permissions and corresponding SQL statements are as follows: