question Re: How can I access MySQL DB present inside the VM from outside, lets say from the host machine using a ODBC driver? in Archives of Support Questions (Read Only)

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

mailtopratikpan — Fri, 10 Nov 2017 18:35:42 GMT

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?

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

jsensharma — Fri, 10 Nov 2017 20:02:06 GMT

@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.html

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

mailtopratikpan — Fri, 10 Nov 2017 20:49:39 GMT

Thanks @Jay Kumar SenSharma ! It worked for me.