Connecting to MariaDB 10.2.34 for LINUX CentOS 7.8

MariaDB 10.2.34 for LINUX CentOS 7.8  is a community-developed SQL database server that is widely in use around the world due to its enterprise features, flexibility, and collaboration with leading tech firms.

This is a quick deployment and ready-to-run image.
Simple and rapid installation. Easy to maintain.

Connecting to MariaDB by HeidiSQL through the SSH tunnel

Before starting, the following components should be installed:

1. MySQL Server – Download
2. PuTTY – Download

Connection setup using HeidiSQL

1. Install the app HeidiSQL and run it – Download
2. In the lower-left corner click on the <New> button to create a new session.

3. In the “Network Type”  field select the “MariaDB or MySQL (SSH Tunnel)”

4. Go to the appeared “SSH tunnel” tab.

5. In the “plink.exe location” field click on the folder icon and then select the “plink.exe” file in the folder, where the PuTTY was installed (by default the file is located on the next path C:\Program Files\PuTTY ).

6. In the “SSH host + port” field enter the address of the virtual machine.
7. In the “Username” and “Password” fields type the data to connect to the virtual machine.
8. Go back to the “Settings” tab.
9. To connect to the DBMS with the root rights, leave the “User” and “Password” fields with no changes.
10. Click <Save> left in the bottom and after click <Open> to connect to DBMS.