Skip to main content

MySQL

The MySQL connector for rudol allows you to connect your MySQL 8+ databases.

info

Your MySQL server instance must be publicly available through a resolvable DNS hostname or public IPv4, see Security Guidelines to know more on how to apply firewall restrictions

Connection parameters

NameTypeDescription
HostnametextPublicly accesible MySQL server DNS hostname
PortnumberServer port number (3306 by default)
UsertextMySQL user name, see User permissions
PasswordpasswordMySQL user password

User permissions

In order to grant rudol the necessary permissions to fetch your database metadata we recommend you to create a new MySQL user with access restricted only to the information_schema database.

Here is a sample code to create a new user for rudol with minimal permissions for metadata scan:

CREATE USER 'rudol_user'@'52.6.101.83' IDENTIFIED BY 'super-secret-password';

GRANT SELECT ON information_schema.`COLUMNS` TO 'rudol_user'@'52.6.101.83';
GRANT SELECT ON information_schema.`TABLES` TO 'rudol_user'@'52.6.101.83';
info

If you want to use Data Quality features these permissions won't be enough: you'll have to grant SELECT to each table you'd like to run tests for, and CREATE TEMPORARY TABLE to run validations without locking tables.