How can we connect to MaraiDB running in VM from host?

Hello,

I have a well configured instance of Frappe/ERPNext running in a VM.

I have a need to access MariaDB in the VM to make changes to data as wells test SQL queries. For this I want to use a RDBMS Tool called HeidiSQL (https://www.heidisql.com/).

Can someone guide me as to how to set this up?

TIA

Yogi Yang