Creating a MySQL connection
Warning
When connecting to an external data source (that's not a Yandex.Cloud resource), grant access to the source for the DataLens IP address ranges.
178.154.242.176/28
178.154.242.192/28
178.154.242.208/28
178.154.242.128/28
178.154.242.144/28
178.154.242.160/28
Connecting to MySQL
To create a MySQL connection:
-
Go to the connections page.
-
Click Create connection.
-
Select the MySQL connector.
-
Enter a Connection name. You can set any name.
-
Select the connection type:
Select in Yandex.CloudSpecify manuallySpecify the connection parameters for the MySQL DB available in Yandex.Cloud:
-
Cluster. Specify a cluster from the list of available MySQL clusters. If you don't have an available cluster, click Create new.
Note
The MySQL clusters are shown in the list of clusters:
- With the permissions for the user that creates the connection.
- Created in the same folder with the DataLens instance.
-
Hostname. Select the host name from the list of hosts available in the MySQL cluster.
-
Port. Specify the MySQL connection port. The default port is 3306.
-
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 user.
Specify the connection parameters for the external MySQL database:
- Hostname. Specify the MySQL host path or IP address.
- Port. Specify the MySQL connection port. The default port is 3306.
- Username. Specify the username for the MySQL connection.
- Database name. Specify the name of the database to connect to.
- Password. Enter the password for the user.
-
-
Click Save. The connection appears in the list.
Note
You can check the host connection before creating it. To do this, click Check connection.