Usage Guidelines – Debian 10 with MariaDB 10.5

MariaDB 10.5

Debian 10

Connecting to MariaDB by HeidiSQL through the SSH tunnel

Before you start, make sure you have the following components installed:

  1. MySQL Server – Download
  2. PuTTY – Download

Connection setup using HeidiSQL

  1. Install the app HeidiSQL and run it – Download
  2. Click on the <New> button in the lower left corner to create a new session.
  1. In the “Network Type” field, select the “MariaDB or MySQL (SSH Tunnel)”
  1. Go to the “SSH tunnel” tab
  1. In the “plink.exe location” field, click on the folder icon and then select the “plink.exe” file from the folder, where the PuTTY was installed. By default, the file is located at C:\Program Files\PuTTY
  1. In the “SSH host + port” field, enter the address of the virtual machine.
  2. In the “Username” and “Password” fields, type the data to connect to the virtual machine.
  3. Go back to the “Settings” tab. 
  4. To connect to the DBMS with the root rights, leave the “User” and “Password” fields unchanged.
  5. Click <Save> at the bottom left and after click <Open> to connect to DBMS.