2.7.2.2.1. Setting up a database connection in HeidiSQL

Before connecting, make sure that the IP from which you will connect is added to the list of allowed in security settings MySQL.

To connect to a database using HeidiSQL, do the following:

1. Click "New» («Create a »):
2. Fill in the fields on the "Settings» («Settings»):
   • «Network type» («Network type") - make sure"MariaDB or MySQL (TCP/IP)».
   • «Hostname / IP» («Hostname / IP") - specify the host from data to connect to the database.
   • «User» («User) - specify the login from data to connect to the database.
   • «Password» («Password") - enter the password from data to connect to the database.
   • «Port» («Port ") - make sure the default port is specified 3306.
   • «Databases» («Database») - specify the name of the database from data to connect to the database.
3. Click "Open» («Open") And in the window that appears, specify whether you want to save the specified connection settings.