How can I access MySQL DB present inside the VM from outside, lets say from the host machine using a ODBC driver?

[#1]

I am using Hortonworks HDP 2.6 sandbox. I need to access the MySQL DB from outside using MySQL ODBC driver. What parameters should I specify in the ODBC driver?

[#2 · Accepted solution]

@Pratik Panda

The default MySQL port 3306 is not defined in the HDP sandbox Port forwarding rules so by default it can not be accessed outside of Sandbox.

Virtual Box --> HDP2.6 Sandbox --> Settings --> Network --> Advanced Options --> Port Forwarding

.

Please check the following link to know about altering the Network Port Forwarding Rules:

https://community.hortonworks.com/articles/65914/how-to-add-ports-to-the-hdp-25-virtualbox-sandbox.h...

.

[#3]

Thanks @Jay Kumar SenSharma ! It worked for me.