Create a MySQL connection

Preview

The MySQL connector is in Public Preview. Contact your Databricks account team to request access.

Create a MySQL connection in Catalog Explorer to store authentication credentials for Lakeflow Connect ingestion. Any user with the USE CONNECTION privilege on the connection can then create MySQL ingestion pipelines without needing direct access to the credentials.

Alternatively, admin users can create a connection and a pipeline at the same time in the data ingestion UI. See Create an ingestion pipeline.

For privilege requirements, see Connect to managed ingestion sources.

Prerequisites

Complete the source setup. Use the authentication details you obtain to create the connection.

Create a connection

1. In the Databricks workspace, click Catalog > External locations > Connections > Create connection.
2. On the Connection basics page of the Set up connection wizard, specify a unique Connection name.
3. In the Connection type drop-down menu, select MySQL.
4. (Optional) Add a comment.
5. Click Next.
6. On the Authentication page, enter the following:
   • Host: The MySQL domain name.
   • User and Password: The MySQL login credentials of the replication user.
7. Click Create connection.

note

The Test Connection button might fail for MySQL users using sha256_password or caching_sha2_password authentication. This is a known limitation. You can still proceed with creating the connection.

Next steps

Create an ingestion pipeline.