> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/destinations/mysql/how-to-set-up-your-mysql-database-as-a-destination-in-daton.md).

# 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**](/daton/integrations/destinations/mysql/how-to-set-up-a-mysql-database-for-integrating-with-daton.md)

## 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="/files/DW28Yy3uqHIFNoEYcRNb" 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="/files/gmPt1vP4nlFsa5ZoF2Mc" alt=""><figcaption></figcaption></figure>
5. Select the **Schema** of your choice and click **Submit.** A message will confirm successful integration.

   <figure><img src="/files/ruO2bJeTJagzAw6jdLOZ" 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 %}