tencent cloud

Creating Account
Last updated: 2025-10-23 19:16:48
Creating Account
Last updated: 2025-10-23 19:16:48
Besides the default account created by the system, you can create other database accounts in the console as needed.

Directions

1. Log in to the TDSQL-C for MySQL console.
2. Select a region at the top and proceed according to the actually used view mode:
Tab view
List view
Click Target Cluster in the cluster list on the left to enter the cluster management page.

Find the target cluster in the cluster list and click the Cluster ID or Manage in the Operation column to enter the cluster management page.

3. On the cluster management page, select the Account Management tab and click Create Account.


4. In the Create Account window, set the following information, and click OK.

Parameter
Description
Account Name
Specify a database account name. It should contain 1 to 30 characters consisting of letters, digits, and special characters (_). It should start with a letter and end with a letter or digit.
Host
Specify one or more host addresses for accessing the database. IP addresses and % are supported. Separate multiple host addresses by delimiters, including line breaks, spaces, and semicolons (;), commas (,), and vertical bars (|).
Example 1: Enter % to indicate no limit on the IP range, that is, clients at all IP addresses are allowed to use this account to access the database.
Note:
If % is entered as the host address, account security risks, such as malicious connections and brute force cracking, may occur. It is recommended to enter specific host addresses to access the database.
Example 2: Enter 10.5.10.% to indicate that clients with an IP range within 10.5.10.% are allowed to use this account to access the database.
Set Password
Specify a password. It should contain 8 to 64 characters consisting of any three types of the following characters: uppercase letters, lowercase letters, digits, and special characters (~!@#$%^&*_-+=`|\\(){}[]:;'<>,.?/).
Confirm Password
Enter the same account password again.
Maximum Connections
Enter a number to limit the number of connections to the account. Value range: 1 to 10240.
If this field is not specified, no additional limit is set. The maximum number of connections to the account is 10,240.
For core transaction business, 50 to 200 connections are allowed. Set the value based on the actual business.
For internal operation systems, 20 to 100 connections are allowed. Set the value based on the actual business.
For administrator/personal accounts, 2 to 10 connections are allowed. Set the value based on the actual business.
Remarks
Remarks can contain up to 255 characters.
5. After the database account is created successfully, you can manage it in the database account list with the operations, such as permission modification, password reset, and account setting modification.
Note:
After the read-only analysis engine is enabled, the system creates a database account named "txsqlPlugins_analytics_repl" by default. This account is used by the read-only analysis engine to pull data from the read-write instance for use. Do not delete this account.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback