What are the reasons why Personal Edition login errors occur? How can I handle these errors?
Cause 1: You have entered an incorrect database account or password.
Enter the correct account and password.
Cause 2: You have not authorized the DMC server address to access the database. You will be prompted for such authorization on the error page for the IP address in the security group or database account.
Authorizing IP address in the security group
Below are the directions for TencentDB for MySQL.
Log in to the TencentDB for MySQL console. In the instance list, click the instance ID or click Manage in the Operation column. On the instance management page you enter, select the ** Security Group** tab. In the Added to security group section, click the security group ID to go to the Security group rules page. Select the Inbound rules tab, click Add rule, and enter the IP address prompted on the error page.
Log in to the TencentDB for MySQL console. In the instance list, click the instance ID or click Manage in the Operation column. On the instance management page you enter, select the Database Management > Account Management tab. Find the account for which you want to modify the host and click More > Modify Host in the Operation column. In the pop-up window, enter the IP address prompted on the error page.
Why Does SQL Query Display Garbled Characters?
The default query encoding format for DMC Personal Edition is UTF-8. Check the character_set_server parameter of the source database. If it is not UTF-8, you can modify it in the DMC interface.
Why Does a Long SQL Query Terminate Unexpectedly?
This may be caused by a timeout on the DMC platform. The default timeout is 20 seconds. After the timeout, the SQL query continues running in the backend.
Why Is SQL Execution Time Longer Than Expected?
The execution time displayed in DMC includes the platform’s own overhead. For database performance testing, it is recommended to use a CVM in the same region for connection testing.
Why Do Columns Misalign in Excel After Exporting Data in the Personal Edition?
This may be caused by the presence of delimiter symbols in the data.
Enterprise Edition FAQs
Which Operations Support Ticket Submission for Approval in the Enterprise Edition?
Permission applications, SQL changes, data imports, and data exports all support ticket submission for approval.
Why Does the Same User Review a Ticket Multiple Times?
Tickets are reviewed based on roles. If a user holds multiple roles, they need to review the ticket multiple times.
