MySQL Destination

Updated on

Sep 5, 2024

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.

Schema information

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. {%dropdown-button name="user-name"%}

{%dropdown-body name="user-name"%}

The maximum length is 32 characters.

{%dropdown-end%}

Enter the Password.
Enter the Database Name. {%dropdown-button name="database-name"%}

{%dropdown-body name="database-name"%}

The maximum length is 64 characters.

{%dropdown-end%}

Select the necessary Use static IP option from the dropdown. {%dropdown-button name="use-static-ip"%}

{%dropdown-body name="use-static-ip"%}

Select Yes for Use static IP option if you allow Improvado to connect your database by the static IPs mentioned on the Destination connection page.

Select No if you have permitted access to your database from any IP. In this case, Improvado will connect your database using dynamic IPs not listed on the Destination connection page.

{%dropdown-end%}