https://community.cloudera.com/t5/Support-Questions/how-to-access-mysql-in-hadoop-VM-from-host-machine/m-p/138737#M101366 <P><A rel="user" href="https://community.cloudera.com/users/4700/inamrehman05.html" nodeid="4700">@Inam Ur Rehman</A></P><P>Your latest query is not very clear to me. Can you please elaborate more.</P><P>If you want to access the DB schema of a remote mysql DB in your local mysql then one option will be to export the DB dump of the remote DB and then import the DB dump to your local machine.</P><P><STRONG>Example: importing DB dump:</STRONG></P><PRE>mysql -u ambari -pbigdata ambari &lt; ambari_mydb_current.sql</PRE><P> Here assuming that the DB username is "ambari" and password is "bigdata" and the database name is 'ambari" which may be different in your case. </P><P><STRONG>Example: Exporting DB dump:</STRONG></P><PRE>mysqldump ambari &gt; /tmp/mydir/ambari_mydb_current.sql</PRE><P>.</P> Thu, 09 Mar 2017 18:24:49 GMT jsensharma 2017-03-09T18:24:49Z