---
metadata:
  - name: generator
    content: Diplodoc Platform v5.63.0
alternate:
  - en/operations/connection/create-mysql
  - ru/operations/connection/create-mysql
  - href: en/operations/connection/create-mysql.md
    type: text/markdown
    title: Markdown version
csp:
  - script-src:
      - https://mc.yandex.ru
    img-src:
      - https://mc.yandex.ru
    connect-src:
      - https://mc.yandex.ru
      - wss://mc.yandex.ru
    child-src:
      - 'blob:'
      - https://mc.yandex.ru
    frame-src:
      - 'blob:'
      - https://mc.yandex.ru
    frame-ancestors:
      - 'blob:'
      - https://mc.yandex.ru
canonical: en/operations/connection/create-mysql.html
title: How to create a MySQL® connection in DataLens On-premises
description: >-
  In this tutorial, you will learn how to connect to MySQL® in DataLens
  On-premises.
vcsPath: en/operations/connection/create-mysql.md
---

# Creating a connection to MySQL® in DataLens On-premises



To create a MySQL® connection:

1. Go to the [workbook](../../workbooks-collections/index.md) page or create a new one.
1. In the top-right corner, click **Create** → **Connection**.
1. Select the **MySQL®** connection.
1. Specify the connection parameters for the external MySQL® database:

   <!-- source: en/_includes/datalens/datalens-db-connection-parameters-mysql.md -->
   * **Host name**: Specify the path to a master host or a MySQL® master host IP address. You can specify multiple hosts in a comma-separated list. If you fail to connect to the first host, DataLens will select the next one from the list.
   * **Port**: Specify the MySQL® connection port. The default port is 3306.
   * **Path to database**: Specify the database name.
   * **Username**: Specify a username for the MySQL® connection.
   * **Password**: Specify a password for the user.
   * **Cache TTL in seconds**: Specify cache TTL or leave the default value. The recommended value is 300 seconds (5 minutes).

   <!-- source: en/_includes/datalens/datalens-db-connection-sql-level-3.md -->
   * **Raw SQL level**: Enables you to use an ad-hoc SQL query to [generate a dataset](../../dataset/settings.md#sql-request-in-datatset). This option is disabled by default. When enabling it, you will need to select the raw SQL level:

      * **Subqueries only**: Describe dataset sources using [SQL queries](../../dataset/settings.md#sql-request-in-datatset).
      * **Subqueries and parameters**: Describe dataset sources using SQL queries and use [source parameterization](../../dataset/settings.md#parametrization).
      * **SQL to read**: Describe dataset sources using SQL queries, use source parameterization, [create QL charts](../../concepts/chart/ql-charts.md), and execute read-only SQL queries.
   <!-- endsource: en/_includes/datalens/datalens-db-connection-sql-level-3.md -->
   <!-- endsource: en/_includes/datalens/datalens-db-connection-parameters-mysql.md -->

1. Optionally, test the connection by clicking **Check connection**.
1. Click **Create connection**.
1. Enter a name for the connection and click **Create**.


## Additional settings {#additional-settings}

You can specify additional connection settings under **Advanced connection settings**:

* **Setting collate in a query**: To explicitly define a collation for database queries, select a mode:

  * **Auto**: Applies the default setting. DataLens decides whether to enable the `utf8mb4_general_ci` locale.
  * **On**: Applies the DataLens setting. The `utf8mb4_general_ci` locale is specified for individual expressions within a query. As a result, the server uses the appropriate sorting logic, regardless of the server settings and specific tables. Use the DataLens setting if your database locale is incompatible with DataLens. 
  * **Off**: Applies the default setting. DataLens only uses database-level locale settings.

* **TLS**: Indicates whether TLS is required. When this option is enabled, the connection requires using SSL.
* **CA Certificate**: To upload a certificate, click **Attach file** and select the certificate file. When the certificate is uploaded, the field shows the file name.
* <!-- source: en/_includes/datalens/operations/datalens-db-connection-export-settings-item.md -->
  **Disable data export**: When this option is on, the data export item will not be available in the <!-- diplodoc:svg ![icon](../../_assets/console-icons/ellipsis.svg) --><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="none" viewBox="0 0 16 16"><path fill="currentColor" fill-rule="evenodd" d="M3 9.5a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3M9.5 8a1.5 1.5 0 1 1-3 0 1.5 1.5 0 0 1 3 0m5 0a1.5 1.5 0 1 1-3 0 1.5 1.5 0 0 1 3 0" clip-rule="evenodd"/></svg> menu for the charts based on this connection. However, you will still be able to copy chart data and take screenshots.
  <!-- endsource: en/_includes/datalens/operations/datalens-db-connection-export-settings-item.md -->