MySQL

MySQL is a popular open source relational DBMS.

RudderStack supports MySQL as a source from which you can ingest data and route it to your desired downstream destinations.

This source is compatible with MySQL v8.0.0 and above.

Granting permissions

RudderStack requires you to grant certain user permissions on your MySQL database to successfully access data from it.

Run the SQL queries listed in the following sections in the exact order to grant these permissions:

Step 1: Creating the user

• Create a new user RUDDER with a password <strong_unique_password> in MySQL:

CREATE USER RUDDER IDENTIFIED BY '<strong_unique_password>';

Set a strong, unique password for creating the user in MySQL.

Step 2: Creating the RudderStack schema and granting permissions

1. Create a dedicated schema _rudderstack.

CREATE SCHEMA _rudderstack;

The _rudderstack schema is used by RudderStack for storing the state of each data sync. This name should not be changed.

2. Grant full access to the schema _rudderstack for the user RUDDER.

GRANT ALL PRIVILEGES ON _rudderstack.* TO RUDDER;

Step 3: Granting permissions on your schema and table

1. Grant access to the user RUDDER to read data from tables in <YOUR_SCHEMA>:

GRANT SELECT ON  <YOUR_SCHEMA>.* TO RUDDER;

Setting up the MySQL source in RudderStack

To set up MySQL as a source in RudderStack, follow these steps:

Naming the source

1. Log into your RudderStack dashboard.
2. From the left navigation bar, go to Source > New Source > Reverse ETL. Then, select MySQL.
3. Assign a name to your source and click Continue.

Configuring the connection credentials

1. Enter the relevant connection details in the Connection Credentials:

• If you have already configured a destination in RudderStack, select the Use Existing Destinations option which will take you to the Schema tab in the source settings.
• To add a new destination from scratch, select the Create New Destination option which will take you to the destination configuration page.

Specifying the data to import

While connecting your MySQL source to a destination, you can configure the data to be imported using any one of the following methods:

• Visual Data Mapper
• JSON mapping

FAQ

What do the three validations under Verifying Credentials imply?

When setting up a Reverse ETL source, once you proceed after entering the connection credentials, you will see the following three validations under the Verifying Credentials option:

These options are explained below:

• Verifying Connection: This option indicates that RudderStack is trying to connect to the warehouse with the information specified in the connection credentials.

If this option gives an error, it means that one or more fields specified in the connection credentials are incorrect. Verify your credentials in this case.

• Able to List Schema: This option checks if RudderStack is able to fetch all schema details using the provided credentials.
• Able to Access RudderStack Schema: This option implies that RudderStack is able to access the _rudderstack schema you have created by successfully running all commands in the User Permissions section.

If this option gives an error, verify if you have successfully created the _rudderstack schema and given RudderStack the required permissions to access it. For more information, refer to the User Permissions sections.

Questions? Contact us by email or on Slack