Skip to main content

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

Create MySQL Data Source

  1. 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.

Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today