# MySQL (Beta)

*MySQL support is currently **in beta**. Please raise any issues you encounter via the chat bubble in the bottom-right of the site, and we'll be happy to help.*

***

### Overview

Our MySQL integration allows you to import your data; allowing you to clean, transform, and ask questions via Chat Explore.

{% hint style="danger" %}
You must allow network traffic from the public IP address `54.197.189.139` in order to allow Akkio to access your data.
{% endhint %}

### Importing Data

To import data, first create a new project.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FyAvYjZJdVfNys2RGIRzF%2Fimage%20(40).webp?alt=media&#x26;token=f7e1a7cc-798f-4f9c-b8b4-980698287332" alt=""><figcaption><p>Create a new project from the homepage.</p></figcaption></figure>

Select the MySQL button.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2Fi4AC8l1DuavreLOEwlG6%2Fimage%20(57).webp?alt=media&#x26;token=85ceb149-6e22-4531-94b7-9a00ba89c3da" alt="" width="450"><figcaption></figcaption></figure>

Click "Connect Dataset" to add a new dataset.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FaMoKobilXXn5zX9xTdeK%2Fimage.png?alt=media&#x26;token=6acc6e13-a3cd-4503-8033-9fb3092a2de9" alt="" width="375"><figcaption></figcaption></figure>

Enter connection details for your MySQL integration:

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FNwm3EDEc4f4Jnd0TVVWo%2Fimage%20(58).webp?alt=media&#x26;token=fa79ab59-f5dc-4033-866d-c4e1672f1469" alt="" width="518"><figcaption></figcaption></figure>

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FOdXEDprOW05FSw6yDqtQ%2Fimage%20(59).webp?alt=media&#x26;token=e343cbdf-4b64-4749-a5ff-82237f46d7c3" alt="" width="520"><figcaption></figcaption></figure>

Select Continue, then add details for the Table name:

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FkqK5O1SXPabEuOPlKrOK%2Fimage.png?alt=media&#x26;token=b82ff9c3-ca54-45a9-ab7e-85e2434a8e73" alt="" width="563"><figcaption></figcaption></figure>

**Make sure your security settings allow us to connect to your database.** You'll need to add our IP Address, `54.197.189.139`, to your security settings so that we can connect and pull your data in.

To pull in your data, input the following:

* **Hostname:** The hostname of your MySQL instance (this looks like the URL).
* **Database Name:** The name of the database within your MySQL instance that your table is inside. NOTE: Each *database* *can* hold multiple *tables*.
* **Username/Password:** Credentials for the database user to authenticate. This user must have read permissions for a table to import and write permissions to deploy.
* **Port:** The port we should use to connect to your database. This is generally `3306` but should be verified.
* **Table Name:** The name of the table to pull from.
* **Use SSL:** Specify whether the MySQL connection uses SSL encryption for security or not.

When complete, hit Continue and Akkio will then validate the connection and begin the import process.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FMKha1ABHu1wNjPmE0TO4%2FScreenshot%202024-02-13%20at%2011.08.10%E2%80%AFAM.png?alt=media&#x26;token=f29b683b-19f9-4850-ba35-bf96cbddc13e" alt="" width="239"><figcaption></figcaption></figure>

If we're successful, you'll move forward to the data loading screen, where your data is syncing behind the scenes.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FqH9fkPU3TonkjoUKOyt0%2Fimage.png?alt=media&#x26;token=75013bf2-6393-4f61-a165-5136a8803c27" alt=""><figcaption></figcaption></figure>

You may need to wait for a little bit for the data to import. Rest assured that we're importing data behind the scenes. Small datasets should only take a few minutes; large datasets may take longer.

Once your data is done importing, you'll see it populate onto the screen.

<figure><img src="https://71333621-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MUiovvmaDi_ad2DYdZ4%2Fuploads%2FT2QiQwdkQMllWZVvNLqc%2Fimage.png?alt=media&#x26;token=dc40fca7-9290-44df-b271-5a7e7bd2543a" alt=""><figcaption></figcaption></figure>

Now, your data is loaded into Akkio and will function normally. If this is your first time connecting data, take a look at [Prepare](https://docs.akkio.com/akkio-docs/prepare-your-data/prepare) to get started.
