# 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="/files/PagMvTAN71kCVKufTIBw" alt=""><figcaption><p>Create a new project from the homepage.</p></figcaption></figure>

Select the MySQL button.

<figure><img src="/files/vFDJvMtMhbBlcuGsAhAR" alt="" width="450"><figcaption></figcaption></figure>

Click "Connect Dataset" to add a new dataset.

<figure><img src="/files/hPrvuMd5AFULLmc7qZDz" alt="" width="375"><figcaption></figcaption></figure>

Enter connection details for your MySQL integration:

<figure><img src="/files/Dd6sEnA0APdHFJouVJQx" alt="" width="518"><figcaption></figcaption></figure>

<figure><img src="/files/Qe6jqWh3QmS1fatFMIcD" alt="" width="520"><figcaption></figcaption></figure>

Select Continue, then add details for the Table name:

<figure><img src="/files/5NmRhWgqpBO8rbWPa3iI" 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="/files/mNZ4edOpZIYq17aXVeYK" 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="/files/tc5pukD5VCrkoqWnZ4vF" 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="/files/5H3YfFSWpUU4eSob4f9l" 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](/akkio-docs/prepare-your-data/prepare.md) to get started.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.akkio.com/akkio-docs/integrations/mysql-beta.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.