Initializing MySQL Instance

Last updated: 2020-10-26 15:46:59

    After creating a TencentDB for MySQL instance, you need to initialize it before you can enable it.


    1. Log in to MySQL Console and select a region. In the instance list, locate the desired "Uninitialized" instance, and click Initialize in "Operation" column.

    2. In the initialization dialog box that pops up, configure the parameters, and click OK.

      • Supported character set: LATIN1, GBK, UTF8, and UTF8MB4 character sets are supported. The default value is UTF8. After initializing the instance, you can also change the character set on the instance details page in the console. For more information, please see Notes on character set.
      • Case-sensitivity of the table name: whether the table name is case sensitive. It is case sensitive by default.
      • Custom port: the database access port, which is 3306 by default.
      • Root account password: the default user name for the new MySQL database is "root". You can set the password of the root account.
      • Confirm password: enter the password again.
    3. In the initialization dialog box that pops up, click OK.

    4. Return to the instance list. After the status of the instance changes to "Running", the instance can be used normally.

    Next Steps

    You can access TencentDB for MySQL over both the private and public networks from a Windows or Linux CVM instance. For more information, please see Connecting to MySQL Instance.