:Tencent Cloud Data Source MySQL

Prerequisites

You must have a Tencent Cloud MySQL database created.

Limits

The service supports MySQL versions 5.5, 5.6, 5.7, and 8.0.

Procedure

1. Add a whitelist entry.

   Before connecting Quick BI to Tencent Cloud MySQL, add the Quick BI IP address to the Tencent Cloud MySQL whitelist.

2. Establish and verify the data source connection.

   1. Log on to the or the international Quick BI console.

   2. Use the guide below to navigate to the data source creation interface.

      1. Enter the data source creation interface via the data source creation entry.

      2. Select the MySQL data source option.

         

      3. Choose Tencent Cloud as the data source type.

         

   3. In the Configure Connection dialog box, configure the connection according to your business needs.

      Name	Description
      Data Source Type	The MySQL data source type supports Alibaba Cloud, Tencent Cloud, Huawei Cloud, Microsoft Cloud, AWS, and self-built. In this example, select Tencent Cloud.
      Display Name	The display name in the datasource config list. The name cannot contain special characters or start or end with spaces.
      Database Address and Port	The public address where the MySQL database is deployed. Log on to the Tencent Cloud MySQL console, enable the public address on the instance product page, and view it in the basic information.
      Database	The name of the database to be connected.
      Username and Password	The username and password that are used to access the MySQL database. Note Ensure that the user who logs on to the MySQL database has the create, insert, update, and delete permissions on the tables in the database.
      Database Version	The version of the MySQL database to be deployed. If the database type is MySQL 5.7 or earlier, select 5.7. If the database type is MySQL 8.0, select 8.0.
      SSL	If the target data source is configured with SSL, you can select the SSL protocol to protect data security.
      Initialize SQL	After enabling, you can configure the SQL statement to be executed after the data source connection is initialized. Only SET statements are allowed for the SQL statement executed after each data source connection is initialized, and statements are separated by periods.
      Enable Upload File Entry	After enabling, file upload is supported.

   4. Click Connection Test to verify the data source's connectivity.

      

   5. Once the test is successful, click OK to finalize the data source addition.