> For the complete documentation index, see [llms.txt](https://docs.telm.ai/telmai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.telm.ai/telmai/connect-to-data/data-connections/mysql.md).

# MySQL

Connect Telmai to a MySQL database hosted on-prem or in the cloud.

## Creating a connection

To connect to MySQL, provide the following details:

1. **Name**: A display name for this connection
2. **Description**: Optional description
3. **Database**: The database name to connect to
4. **Server**: The hostname or IP address of the MySQL server
5. **Port**: The port MySQL is listening on (default: `3306`)
6. **Use SSL**: Whether to require an SSL connection (`true` / `false`)
7. **User**: The username
8. **Password**: The password

<figure><img src="https://604868671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MkO3-a8YVu1iq1jP__S%2Fuploads%2Fgit-blob-5f3e75fab7a49b5fb343ef877513abd06367fa05%2FScreenshot%202026-05-19%20at%203.00.00%20PM.png?alt=media" alt="MySQL connection form"><figcaption><p>MySQL connection form</p></figcaption></figure>

{% hint style="info" %}
In order to connect to a privately hosted instance, the customer will need to whitelist the IPs from Telmai. Please reach out to Telmai support for the updated list of IPs for whitelisting.
{% endhint %}

## Connecting an asset

Once a connection is defined, you can start using it to create assets. Select an existing connection (or create a new one), then choose whether to create assets from an **Existing Table** or a **Custom Query**.

<figure><img src="https://604868671-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MkO3-a8YVu1iq1jP__S%2Fuploads%2Fgit-blob-e674ed6dd1e844fc84560902c5d8b65978652d06%2FScreenshot%202026-05-19%20at%203.00.01%20PM.png?alt=media" alt="MySQL asset configuration step"><figcaption><p>MySQL asset configuration step</p></figcaption></figure>

{% hint style="info" %}
Please ensure that your environment has whitelisted [Telmai IP list](/telmai/api-reference/telmai-ip-list.md).
{% endhint %}