Creating a MySQL connection
Changing connection ranges
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.
Old ranges valid until December 1, 2020
Transition ranges from October 1 to December 1, 2020
During the transition period, add the new ranges to the current ranges. Starting from December 1, leave only the new ranges.
New ranges as of December 1, 2020
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 manually
Specify 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.
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.
You can check the host connection before creating it. To do this, click Check connection.