Skip to main content
To add MySQL as a data source, go to Settings → Workspace → Integrations → Datasources and click New Datasource. Select MySQL and fill in the connection parameters below, then click Test & Save Datasource.

​
Connection parameters

FieldDescription
Connection NameA label for this connection within Datachecks
HostThe server name hosting your database
PortDefault is 3306. Specify an alternative if your server uses a different port
UsernameThe dedicated user for Datachecks
PasswordThe password for the Datachecks user
DatabaseThe name of the MySQL database you want to connect to
SecurityAuthentication methods or encryption settings (for example, SSL/TLS)

​
Setup

Run the following SQL on your MySQL instance to create a dedicated user for Datachecks. 
CREATE DATABASE IF NOT EXISTS datachecks_tmp;
CREATE USER 'datachecks_user'@'%' IDENTIFIED BY 'YourSecurePassword';
GRANT SELECT ON `YourSchema`.* TO 'datachecks_user'@'%';
GRANT ALL ON `datachecks_tmp`.* TO 'datachecks_user'@'%';
FLUSH PRIVILEGES;
The datachecks_tmp database is used for temporary processing and keeps Datachecks operations isolated from your production data.