📣
TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

MySQL - Credentials



This page describes how to create a MySQL - Credentials data source. This data source stores the connection information required to access MySQL and can be reused across multiple MySQL integration tasks.

Use Cases

  • Manage host, port, and account information centrally for multiple MySQL sync tasks
  • Avoid re-entering the same database connection settings in every task
  • Update all dependent tasks in one place when the database endpoint or account changes

Create MySQL - Credentials

  1. Navigate to Data > Data Sources and click Create Data Source.

  2. Select MySQL - Credentials as the service type, then fill in the connection details:

    FieldRequiredDescription
    NameYesA descriptive name for this data source
    HostnameYesMySQL server hostname or IP address
    Port NumberYesMySQL server port (default: 3306)
    DB UsernameYesUsername used to access MySQL
    DB PasswordYesPassword for the MySQL user
    Database NameYesThe source database name
    DB CharsetNoCharacter set (default: utf8mb4)
    Server IDNoUnique binlog replication identifier. Auto-generated if not provided
  3. Click Test Connectivity to validate the connection. If the test succeeds, click OK to save the data source.

Usage Recommendations

  • Use a dedicated MySQL account instead of sharing one with application workloads
  • If you plan to create CDC Only or Snapshot + CDC tasks, make sure the account has replication-related privileges
  • Verify network access, binlog configuration, and permissions before creating downstream tasks

Next Steps

After creating this data source, you can use it to create a MySQL Integration Task.

Was this page helpful?