11)Sqoop Tool8: sqoop-list-databases:

Sqoop Tool8: sqoop-list-databases:
Using list-databases tool to list database schemas present on a server.

Syntax:

$ sqoop list-databases (generic-args) (list-databases-args)
or
$ sqoop-list-databases (generic-args) (list-databases-args)

Common arguments:

Argument	Description
--connect <jdbc-uri>	Specify JDBC connect string
--connection-manager <class-name>	Specify connection manager class to use
--driver <class-name>	Manually specify JDBC driver class to use
--hadoop-mapred-home <dir>	Override $HADOOP_MAPRED_HOME
--help	Print usage instructions
--password-file	Set path for a file containing the authentication password
-P	Read password from console
--password <password>	Set authentication password
--username <username>	Set authentication username
--verbose	Print more information while working
--connection-param-file <filename>	Optional properties file that provides connection parameters
--relaxed-isolation	Set connection transaction isolation to read uncommitted for the mappers.

Command: to list databases
mano@Mano:~$ sqoop-list-databases --connect jdbc:mysql://localhost --username root --password root  

Command: to list databases using verbose, to see more information
mano@Mano:~$ sqoop-list-databases --connect jdbc:mysql://localhost --username root --password root --verbose

Note:
This only works with HSQLDB, MySQL and Oracle. When using with Oracle, it is necessary that the user connecting to the database has DBA privileges.

Please follow the link for further ==>Sqoop_page12