# How to Set up Your MySQL Database as a Destination in Daton

## Pre-requisites

Before attempting to integrate your MySQL database as a destination in Daton, ensure you have the following:

* Active Daton account
* Performed the required configuration as outlined in the subtopic [**How to Set up a MySQL Database for Integrating with Daton**](https://daton-sarasanalytics.gitbook.io/daton/integrations/destinations/mysql/how-to-set-up-a-mysql-database-for-integrating-with-daton)

## Steps to Add MySQL Database as a Destination in Daton

1. Log in to your [Daton account](https://daton.sarasanalytics.com/u/integrations-list) and navigate to the **Destinations** page.
2. Click the **Add New Destination** button and select **MySQL** from the list of options.
3. Enter the Integration Name and click **Next**. A unique name for your MySQL integration. This name will be used to create tables in the data warehouse and cannot be modified later.

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2Fh9QgPbNWVzcDca3XsEj3%2FMySQL%20-1.png?alt=media&#x26;token=3241df49-8940-4237-9eeb-e90fea4fa4ed" alt=""><figcaption></figcaption></figure>
4. Enter the following details to configure the connection to your MySQL database and click **Next**.
   * **MySQL Host**: The IP address or hostname of the MySQL server.
   * **MySQL Port**: The port number of your MySQL server. The default port is 3306.&#x20;
   * **MySQL User**: The username provided for the dedicated user with access to the database.
   * **MySQL Password**: The password provided for the MySQL user.
   * **MySQL Database**: The name of the MySQL database you want to connect to.

     <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FuVi1shYOK4jQ9n4fUCol%2FMySQL%20-2.png?alt=media&#x26;token=1283db45-0f01-4cb3-942c-28f5a2b0bcec" alt=""><figcaption></figcaption></figure>
5. Select the **Schema** of your choice and click **Submit.** A message will confirm successful integration.

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FjHwOFppfVplxvPrcoKfR%2FRDS%20Postgres%20Daton%20inte%20schema%20(2).png?alt=media&#x26;token=62c388d1-59d8-4663-b0fb-9d18afe2077e" alt=""><figcaption></figcaption></figure>

The MySQL database is now configured as a destination in Daton.

{% hint style="info" %}
**Note:** Once the integration is complete, you can query your MySQL database in Daton to create additional schemas and tables as needed.
{% endhint %}