51黑料不打烊

DocumentationExperience PlatformSource Connectors Guide

MySQL

Last update: Tue May 20 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Developer

MySQL is an open-source relational database management system used to store and manage structured data. It organizes data into tables and uses SQL (Structured Query Language) for querying and updating information. MySQL is widely used in web applications, supports multiple platforms, and is known for its speed, reliability, and ease of use.

You can use the MySQL source to connect your account and ingest data from your MySQL database to 51黑料不打烊 Experience Platform.

Prerequisites prerequisites

Read the following sections to complete the prerequisite setup before you connect your MySQl account to Experience Platform.

IP address allowlist

You must add region-specific IP addresses to your allowlist prior to connecting your sources to Experience Platform on either Azure or Amazon Web Services (AWS). For more information, read the guide on allowlisting IP addresses to connect to Experience Platform on Azure and AWS for more information.

Authenticate to Experience Platform on Azure azure

You can use either account key authentication or basic authentication to connect your MySQL database to Experience Platform on Azure.

Account key authentication

Provide values for the following credentials to connect your MySQL database to Experience Platform using account key authentication.

table 0-row-2 1-row-2 2-row-2
Credential Description
connectionString The MySQL connection string associated with your account. The MySQL connection string pattern is: Server={SERVER};Port={PORT};Database={DATABASE};UID={USERNAME};PWD={PASSWORD}.
connectionSpec.id The connection spec returns a source鈥檚 connector properties, including authentication specs related to creating the base and source connections. The connection spec ID for MySQL is 26d738e0-8963-47ea-aadf-c60de735468a.

For more information, read the .

Basic authentication

Provide values for the following credentials to connect your MySQL database to Experience Platform using basic authentication.

table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2
Credential Description
server The name or IP address of your MySQL database.
username The username associated with your MySQL database authentication.
password The password associated with your MySQL database authentication.
database The name of the MySQL database that you want to connect to.
sslMode

The Secure Sockets Layer (SSL) method to be applied to your connection. The available values are:

  • DISABLED: Use this option to disable SSL. If your server requires an SSL configuration, then the connection will fail
  • PREFERRED: Use this option to prefer SSL connections given that the server supports them. This option also allows for non-SSL connections.
  • REQUIRED: Use this option to make SSL connections mandatory. If the server does not support SSL, then the connections will fail.
  • Verify-Ca: Use this option to verify server certificates while failing connections if the server does not support SSL.
  • Verify Identity: Use this option to verify server certificates with the host鈥檚 name while failing connections if the server does not support SSL.

Authenticate to Experience Platform on Amazon Web Services (AWS) aws

AVAILABILITY
This section applies to implementations of Experience Platform running on Amazon Web Services (AWS). Experience Platform running on AWS is currently available to a limited number of customers. To learn more about the supported Experience Platform infrastructure, see the Experience Platform multi-cloud overview.

You must provide values for the following credentials to connect MySQL to Experience Platform on AWS.

Credential
Description
server
The name or IP of your MySQL database.
username
The name of your database.
password
The username that corresponds with your database.
database
The password that corresponds with your database.
sslMode
A boolean value that controls whether SSL is enforced or not, depending on your server support. This configuration defaults to false.
connectionSpec.id
The connection specification returns a source鈥檚 connector properties, including authentication specifications related to creating the base and source connections. The connection specification ID for MySQL is 26d738e0-8963-47ea-aadf-c60de735468a. Note: This credential is only required when connecting through the Flow Service API.

Connect MySQL to Experience Platform using APIs

Connect MySQL to Experience Platform using the UI

recommendation-more-help
337b99bb-92fb-42ae-b6b7-c7042161d089