Creating a MySQL connection

Connecting to MySQL

To create a MySQL connection:

1. Go to the connections page.

2. Click Create connection.

3. Select the MySQL connector.

4. Enter a Connection name. You can set any name.

5. Select the connection type:

   Select in Yandex.Cloud

   Specify 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.

     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.

6. Click Save. The connection appears in the list.