I'm unable to view the databases inside Mysqlworkbench. Instead the following databases are listed : information_schema, hive, mysql, ranger, ranger_audit,test

[#1]

Whenever I execute the following query : sqoop list-databases --connect jdbc:mysql://localhost:3306 --username xxx -password xxx . Only the following tables are displayed information_schema, hive, mysql, ranger, ranger_audit,test, but not the databases which I created inside mysql workbench. Your guidance will be appreciated.

[#2]

@keerthana gajarajakumar

If you have created databases under hcatalog then you won't be able to see it through workbench

[#3]

@keerthana gajarajakumar

See this https://cwiki.apache.org/confluence/display/Hive/HCatalog

[#4]

Thanks @Neeraj Sabharwal. I downloaded the sample employee database from http://dev.mysql.com/doc/employee/en/employees-installation.html and ran the scripts on Mysql Workbench . I've got all the tables and data loaded but then when I executed the sqoop list-databases command the following is not being displayed. Am I missing anything?

[#5]

@keerthana gajarajakumar It looks like that your script creates a database employees

can you try this?

sqoop list-tables --connect jdbc:mysql://localhost:3306/employees --username xxx -password xxx

[#6]

@Neeraj Sabharwal -- Thanks Neeraj. I ran the code you suggested but I'm getting the following error - 16/01/31 23:58:50 ERROR manager.CatalogQueryManager: Failed to list tables com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'employees' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

[#7]

@keerthana gajarajakumar

Could you login to mysql and run show databases;

command is

show databases;

[#8]

@Neeraj Sabharwal -- It's getting listed in mysql workbench but not when I try it on hortonworks sandbox

[#9]

@Neeraj Sabharwal -- Thanks for your reply. When I try executing the following command.. I don't see employees listed below like yours.

[#10]

@keerthana gajarajakumar Try this

grant all privileges on *.* to ‘username’@’%’ identified by ‘userpassword’;