MySQL

1. Create a PostgreSQL Read-Only User

To connect to MySQL, create a user with read-only access to all tables you wish to compare. Include read and write access to a Datachecks-specific dataset:

/* Create the database if it doesn't exist */
CREATE DATABASE IF NOT EXISTS datachecks_tmp;

/* Create a Datachecks user */
CREATE USER 'datachecks_user'@'%' IDENTIFIED BY 'YOURSECUREPASSWORD';

/* Grant read access to compare tables in YourSchema */
GRANT SELECT ON `YourSchema`.* TO 'datachecks_user'@'%';

/* Grant access to all tables in the datachecks_tmp database */
GRANT ALL ON `datachecks_tmp`.* TO 'datachecks_user'@'%';

/* Apply the changes */
FLUSH PRIVILEGES;

Your read-only user now has the necessary permissions for Datachecks to securely connect to your MySQL database.

Datachecks uses the datachecks_tmp schema for temporary processing, ensuring that core data remains untouched during validation and monitoring tasks.

2. Add MySQL as a data source in Datachecks

Go to Settings > Your Workspace > Datasources, click New Datasource, and select MySQL to configure the connection to your database.

Once selected, you’ll be directed to the configuration page. Enter the following details:

Field Name	Description
Host	The name of the server that hosts your database.
Port	The default port is 3306. If your server uses a different port, specify that.
Username	The name of the dedicated user for Datachecks.
Password	The password of the Datachecks user.
Database	The name of the MySQL database (schema) you want to connect to.
Security	Define authentication methods or encryption settings (e.g., SSL/TLS).
Connection Name	A name given to the data connection within Datachecks.

Click Test & Save Datasource. Your data connection is ready!