MariaDB is a database management system, a branch of MySQL. MariaDB is designed to be fully compatible with MySQL, including APIs and command lines, making it easy to be a replacement for MySQL.

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

Connecting to MariaDB on Ubuntu 20.04 by HeidiSQL through the SSH tunnel

Before starting, the following components should be installed:

1. MySQL Server – Download
2. PuTTY – Download

---

1. To connect to the database, you should generate a “Private Key” in advance. This can be done using the following instruction (by choosing the “file format:” option “.ppk” in point 3).

Guide – How To – Create and use Key Pair to connect to a VM

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

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

5. Go to the appeared “SSH tunnel” tab

6. 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 )

7. In the “SSH host + port” field enter the address of the virtual machine
8. In the “Username” field type ubuntu
9. In the “Private Key file” field, specify the path to the key that was created in step # 1
10. Go back to the “Settings” tab
11. To connect to the DBMS with the root rights, leave the “User” and “Password” fields with no changes
12. Click <Save> left in the bottom and after click <Open> to connect to DBMS