MySQL Destination

Updated on May 12, 2025

Note: This article covers the MySQL Destination setup process. It doesn’t cover the DataPrep setup for MySQL.

You can learn how to extract data from MySQL data source here.

Description

MySQL is an open-source relational database management system that enables efficient storage, retrieval, and management of data.

Setup guide

Follow our setup guide to connect MySQL to Improvado.

Permissions

Grant the following permissions:

CREATE TABLE
CREATE INDEX
ALTER TABLE
SELECT
INSERT
DELETE
TRUNCATE

Complete configuration

On the MySQL connection page, fill in the following fields:

Enter a name for your Destination connection in the Title.
Enter the Host.
Enter the Port.
Enter the User Name.

Enter the Password.
Enter the Database Name.

Select the necessary Use static IP option from the dropdown.

Select the necessary Use binary strings option from the dropdown.

‍

Load limits

You can load no more than 300 columns per single load order.

Was this article helpful?