question Re: I'm unable to view the databases inside Mysqlworkbench. Instead the following databases are listed : information_schema, hive, mysql, ranger, ranger_audit,test in Archives of Support Questions (Read Only)

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

keerthanakumar2 — Mon, 01 Feb 2016 06:36:16 GMT

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.

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

nsabharwal — Mon, 01 Feb 2016 07:22:46 GMT

@keerthana gajarajakumar

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

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

nsabharwal — Mon, 01 Feb 2016 07:31:01 GMT

@keerthana gajarajakumar

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

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

keerthanakumar2 — Mon, 01 Feb 2016 07:50:02 GMT

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?

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

amcbarnett — Mon, 01 Feb 2016 07:55:34 GMT

@keerthana gajarajakumar Try this

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

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

nsabharwal — Mon, 01 Feb 2016 07:57:39 GMT

@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

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

keerthanakumar2 — Mon, 01 Feb 2016 07:58:36 GMT

@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)

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

nsabharwal — Mon, 01 Feb 2016 08:00:29 GMT

@keerthana gajarajakumar

Could you login to mysql and run show databases;

command is

show databases;

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

keerthanakumar2 — Mon, 19 Aug 2019 10:40:48 GMT

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

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

nsabharwal — Mon, 01 Feb 2016 08:05:31 GMT

@keerthana gajarajakumar

I loaded the same databases in my system. See this

There is chance that you ended up loading it into default or test db. I suggest to load the data using mysql prompt

[root@sandbox test_db]# sqoop list-databases --connect jdbc:mysql://localhost:3306 --username root --password xxx

Warning: /usr/hdp/2.3.2.0-2950/accumulo does not exist! Accumulo imports will fail.

Please set $ACCUMULO_HOME to the root of your Accumulo installation.

16/02/01 00:04:25 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.3.2.0-2950

16/02/01 00:04:25 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.

16/02/01 00:04:26 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.

SLF4J: Class path contains multiple SLF4J bindings.

SLF4J: Found binding in [jar:file:/usr/hdp/2.3.2.0-2950/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: Found binding in [jar:file:/usr/hdp/2.3.2.0-2950/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.

SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]

information_schema

demomysql

employees

hive

mysql

ranger

ranger_audit

test

[root@sandbox test_db]#

[root@sandbox test_db]# mysql < employees.sql

INFO

CREATING DATABASE STRUCTURE

INFO

LOADING departments

INFO

LOADING employees

INFO

LOADING dept_emp

INFO

LOADING dept_manager

INFO

LOADING titles

INFO

LOADING salaries

data_load_time_diff

00:00:16

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

nsabharwal — Mon, 19 Aug 2019 10:40:40 GMT

@keerthana gajarajakumar

See the above output of

sqoop list-databases --connect jdbc:mysql://localhost:3306 --username root --password root

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

keerthanakumar2 — Mon, 19 Aug 2019 10:40:26 GMT

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

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

nsabharwal — Mon, 01 Feb 2016 08:12:24 GMT

@keerthana gajarajakumar I suggest to load the file from OS.

yum -y install git

git clone https://github.com/datacharmer/test_db.git

[root@sandbox ~]# cd test_db/

[root@sandbox test_db]# ls

Changelog employees.sql load_dept_emp.dump load_salaries1.dump load_titles.dump sakila test_employees_md5.sql

employees_partitioned_5.1.sql images load_dept_manager.dump load_salaries2.dump objects.sql show_elapsed.sql test_employees_sha.sql

employees_partitioned.sql load_departments.dump load_employees.dump load_salaries3.dump README.md sql_test.sh

[root@sandbox test_db]# mysql < employees.sql

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

keerthanakumar2 — Mon, 01 Feb 2016 08:22:34 GMT

@Neeraj Sabharwal -- Your suggestion to download using git clone seems to work. However when I ran this code, [root@sandbox test_db]# mysql < employees.sql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) . So, will this code work? [root@sandbox test_db]# mysql -u root -p < employees.sql

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

nsabharwal — Mon, 01 Feb 2016 08:25:12 GMT

See this @keerthana gajarajakumar

Dont put any space after p and provide password.

[root@sandbox test_db]# mysql -u root -proot < employees.sql

INFO

CREATING DATABASE STRUCTURE

INFO

LOADING departments

INFO

LOADING employees

INFO

LOADING dept_emp

INFO

LOADING dept_manager

INFO

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

nsabharwal — Mon, 01 Feb 2016 08:26:26 GMT

@keerthana gajarajakumar In case of mysql password

[root@sandbox test_db]# mysql -u root -proot < employees.sql

INFO

CREATING DATABASE STRUCTURE

INFO

LOADING departments

INFO

LOADING employees

INFO

LOADING dept_emp

INFO

LOADING dept_manager

INFO

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

keerthanakumar2 — Mon, 01 Feb 2016 08:37:51 GMT

@Neeraj Sabharwal -- Now, I made few changes when I ran this code (sudo /usr/bin/mysql_secure_installation), guess it's wrong. Despite entering my correct mysql password, I'm getting the following error: Enter current password for root (enter for none): ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

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

keerthanakumar2 — Mon, 01 Feb 2016 08:38:28 GMT

@Neeraj Sabharwal Do you know how to fix this?

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

nsabharwal — Mon, 01 Feb 2016 08:40:34 GMT

@keerthana gajarajakumar

see this http://www.cyberciti.biz/faq/mysql-change-root-password/

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

keerthanakumar2 — Mon, 01 Feb 2016 09:31:48 GMT

@Neeraj Sabharwal -- It worked. Thanks a lot for your time and suggestions:)