Embark on a data revolution with the unbeatable combination of MariaDB Server and Ubuntu 22.04, revolutionizing the way you handle and optimize your valuable assets.

Effortless installation. Ready-to-run with easy maintenance. Explore now for a smooth experience!

Connecting to MariaDB Server on Ubuntu Server 22.04 by HeidiSQL through the SSH tunnel

Before starting, the following components should be installed:

HeidiSQL – Download
PuTTY – Download

For the connection to the server, you should know the IP address of the VM. You can find it in the personal account of Azure. Select the virtual machine from the list. By clicking the item “Overview”, your IP is displayed in the “Public IP Address” line.

To manage the MariaDB server manually, you should connect to a VM.
With OpenSSH

In the Windows 10 operating system (starting with version 1809 ), an OpenSSH client is available, with which you can connect to Linux servers via SSH. If Windows 10 is suitable and the OpenSSH client is installed, you can start connecting via SSH. To do this, launch a normal Windows command prompt and enter the command “ssh user@*vm_ip*” (1), where “user” is the username that was specified while creating the virtual machine and “*vm_ip*” is the VM IP address.

Then type “Yes” (2) and enter a password (3) that was specified while creating the virtual machine.

With the PuTTY application

Run Putty, enter the VM address in the “Host” field (1), and click “Open” (2) to connect.

In the opened console, you will need to enter a username (1) and a password (2) that were specified while the VM was being created (you’ll not see the password in the console while entering it).

To obtain connection credentials, enter the command

$sudo cat /root/mariadb_connect

Run HeidiSQL. In the lower-left corner, click on the New button to create a new session

In the Network Type field, select MariaDB or MySQL (SSH Tunnel) (1), enter Username (2) and Password (3) from step 4. Leave all other fields as default.