Connect MySQL

The MySQL source reads tables and views from a MySQL server into the Lake. Use this page to fill in each field of the MySQL form. The steps shared by every SQL engine are on Connect a SQL database. For a MariaDB server, see Connect MariaDB.

---

Prerequisites

• A MySQL user with read access to the databases and tables you want to load.
• The server accepts connections from DataMind on its port, usually 3306.
• Create/Edit Lake Objects in DataMind. See Who can do what in the Lake.

---

Add the source

1. Open Lake and click Add datasource, or open the New menu in the toolbar above the tree.
2. Choose MySQL in the picker.
3. Fill in the General, Connection and Datetime steps as described below.
4. Click Add.

---

Connection settings

General step

Name (Mandatory)

• The name the source carries in the Lake.
• At least 3 characters. The field reads Enter name until you type.

Code (Mandatory)

• A short code, at least 2 characters, made of letters and numbers only.
• It becomes the prefix of the table names the source forms. It fills in from Name while you type; edit it to set your own.
• Name and Code cannot be changed after the source is created.

Folder (Optional)

• The Lake folder the source is filed under. Leave it empty to keep the source at the top level.

Connection step: Address

Paste connection string (Optional)

• Click Paste connection string, paste a JDBC URL or a URI, and click Fill.
• Example: jdbc:mysql://<server>:3306/sales.
• The string fills Host, Port and Database. A password inside it is never read.

Host (Mandatory)

• The server name or IP address of the MySQL server.

Port (Mandatory)

• The port MySQL listens on.
• Default: 3306. A whole number from 1 to 65535.

Database (Optional)

• The database to read from.
• Leave it empty to load all databases the user can read. The placeholder reads All databases.
• With a database entered, the Lake lists that database only.

Connection step: Authentication

Username (Mandatory)

• The MySQL user the source signs in with.
• Users on the default MySQL 8 authentication (caching_sha2_password) can sign in.

Password (Mandatory)

• The password of that user.
• After you save, the field reads Stored password with Replace beside it. The password is never shown again.

Connection step: Security

SSL/TLS (Optional)

• Encrypts the connection between DataMind and the server.
• Default: off.
• The server certificate is not validated, so a self-signed certificate works.

Datetime step

Timezone (Optional)

• The IANA timezone the server writes its datetime values in, for example Europe/Berlin.
• Leave it empty when the server runs in the same timezone as the platform.

Datetime values (Optional)

• Keep as written (wall clock) (default) stores each value exactly as the server shows it.
• The other option converts each value from the source timezone into platform time on load.

Timezones and datetime values explains both settings in full.

---

Test and save

1. On the Connection step, click Test connection. The button reads Testing… while it runs.
2. Connection test passed means DataMind reached the server and signed in. Connection test failed shows the server's message with a copy button; fix the settings and test again.
3. On Datetime, check the summary: Name, Server, Database (or All databases), Username and Security.
4. Click Add. Then import its tables.

The test is optional and never saves the source. To edit or duplicate the source later, see Connect a SQL database.

---

Questions, answered

Why does each MySQL database show one schema named default?

MySQL has no schemas inside a database: a database and a schema are the same thing. The Lake shows each MySQL database as a database with a single schema called default, and the tables sit under it.

Does the source work with MySQL 8 authentication?

Yes. Users that sign in with caching_sha2_password, the default on MySQL 8, can connect. Enter the user name and password as usual.

Can I limit the source to one database?

Yes. Enter the database name in Database. The Lake then lists only that database; leave the field empty to pick tables from every database the user can read.

My server uses a self-signed certificate. Will SSL/TLS work?

Yes. With SSL/TLS on, the connection is encrypted and the server certificate is not validated, so a self-signed certificate is accepted.

Can I send data back to MySQL?

Yes. MySQL is also offered as a Writeback destination, with the same connection fields. See Add and manage destinations.