Connection guide

Connect MySQL

To connect Unity Layer to MySQL, create a dedicated user with read-only access. You will need host, port, database name, and credentials from your DBA.

Create a dedicated user

Create a user for Unity Layer. Replace your_secure_password with a strong password.

CREATE USER 'unitylayer_user'@'%' IDENTIFIED BY 'your_secure_password';

Grant required permissions

Grant SELECT on your database. Replace your_database with the actual database name.

GRANT SELECT ON your_database.* TO 'unitylayer_user'@'%';
FLUSH PRIVILEGES;

Verify user permissions

Confirm the user exists and has the expected grants.

SHOW GRANTS FOR 'unitylayer_user'@'%';

When setup is complete, open Connect database in the data catalog to enter credentials and test the connection.