MySQL

Overview

Use this connector to extract metadata from MySQL databases.

Create User & Grant Permissions

Run the following SQL commands to create a dedicated user and grant the required read-only permissions:

• CREATE USER '<username>' IDENTIFIED BY '<password>';
• GRANT SELECT ON <database_name>.* TO '<username>';
• GRANT SELECT ON <schema_name>.* TO '<username>';

Connection Setup in Connetra

When adding a data connector in Connetra, provide the following details. When connecting to MySQL in Connetra, use the username/password you’ve created here.

• Configuration name: A user-friendly label for this connection. It helps team members identify and select the connector within Connetra
• Host/server: The network address or domain name of the database server where your data is stored.
• Port: The communication port used to connect to the database
• User: The database account Connetra will use to connect and retrieve metadata. This user should have read-only permissions.
• Password: The password associated with the user account above, used to authenticate the connection.

Before you can save the data connector you must first test the connection.