Use a MySQL database for synthetic data

To use a MySQL database as a source for original data as well as a destination to deliver synthetic data, you need to create MySQL connectors.

For each MySQL data source or destination, you need a separate connector.

Prerequisites

To create a MySQL connector, you need the MySQL database connection details.

Create a new MySQL connector from the Connectors page.

Steps

From the Connectors page, select MySQL under the Connect your data header.
On the New connector modal, configure the connector.

Field	Description
Name	Enter a name that you can distinguish from other connectors.
Access type	Select whether you want to use the connector as a source or destination.
Host	The MySQL database hostname.
Port	The database port.
Username	The MySQL database username.
Password	The MySQL database password.

Click Save to save your new MySQL connector.
- MOSTLY AI tests the connection. If you see an error, check the connection details, update them, and click Save again.
- You can click Save anyway to save the connector and disregard any errors.

What’s next

Depending on whether you created a source or a destination connector, you can use the connector as: