question Re: how to access mysql in hadoop VM from host machine? in Support Questions

question Re: how to access mysql in hadoop VM from host machine? in Support Questions https://community.cloudera.com/t5/Support-Questions/how-to-access-mysql-in-hadoop-VM-from-host-machine/m-p/138734#M101363 <A rel="user" href="https://community.cloudera.com/users/4700/inamrehman05.html" nodeid="4700">@Inam Ur Rehman</A> After logging in to the mysql you can switch to the desired database schema using "mysql> use $SCHEMA_NAME;"Example: Shows how to use "ranger" db schema.<PRE># mysql -u root -p Enter password: hadoop Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3126 Server version: 5.6.33 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | EmpDB | | hive | | mysql | | performance_schema | | ranger | +--------------------+ 6 rows in set (0.01 sec) mysql> use ranger; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +--------------------------------+ | Tables_in_ranger | +--------------------------------+ | vx_trx_log | | x_access_type_def | | x_access_type_def_grants | | x_asset | | x_audit_map | </PRE>. Mon, 06 Mar 2017 14:43:47 GMT jsensharma 2017-03-06T14:43:47Z