Creating a MySQL connection

    To create a MySQL connection:

    1. Go to the connections page.

    2. Click Create connection.

    3. Select the MySQL connector.

      Important

      When connecting to an external data source (which is not a Yandex.Cloud resource), grant access to the source for the following ranges of DataLens IP addresses:

      • 77.88.39.88/29
      • 93.158.158.96/29
      • 93.158.156.80/29
      • 77.88.39.224/28
      • 37.9.126.112/28
      • 37.9.65.32/28
    4. Specify the connection parameters:

      • Connection name. Enter any name for the connection.
      • Hostname or IP. Set the path to the MySQL host.
      • Port. Set the MySQL connection port.
      • Database name. Specify the name of the database to connect to.
      • Username. Specify the username for the MySQL connection.
      • Password. Enter the password for the specified user.
    5. Click Connect. The connection appears in the list.

    You can check the host connection before creating it. To do this, click Check connection.