Connection to private DB

Question

Hello good afternoon, I want to tell you that I have a VM (Ubuntu 20.04) and a BD (Mysql).
The database has a private connection, so if I want to connect from my computer via MariaDB, Navicat, or similar, I won't be able to, since it's private.
How can I connect from any of these software while keeping the database connection private?
I understand that there should be an option to do this.
From the VM I can connect to mysql normally, but from my personal machine I can't access the DB.

Answer 1

Hi,

You can ssh into your Azure VM and use Local Port Forwarding:

https://linuxize.com/post/how-to-setup-ssh-tunneling/

Please see Local Port Forwarding section in the blog post from above.

Hope this helps!