In mysql - retail_export database is missing

mysql> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| abc1 |
| demo |
| hadoopguide |
| retailDB |
±-------------------+
5 rows in set (0.02 sec)

@Ravinder_Singh Can you elaborate your query?

I am trying to learn sqoop export and need some database where can create some table. I saw in one of the course ‘retail_export’ being used.

You can refer this below link.

mysql> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| abc1 |
| demo |
| hadoopguide |
| retailDB |
±-------------------+

Sqoop export command:
sqoop export --connect jdbc:mysql://ms.itversity.com/retailDB --username retail_user --password itversity --export-dir /apps/hive/warehouse/training_sqoop_retail.db/daily_revenue02 --table retailDB_DR02
19/09/01 15:20:38 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.6.5.0-292
19/09/01 15:20:38 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
19/09/01 15:20:38 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
19/09/01 15:20:38 INFO tool.CodeGenTool: Beginning code generation
19/09/01 15:20:39 ERROR manager.SqlManager: Error executing statement: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ‘retail_user’@’%’ to database 'retailDB’

What is the username?

Any clue? as I am stuck here and can’t proceed

Hi Administrator,

Please help here and I am stuck with my learning and no response heard since 6d.

Figured out.
Seems like while showing database on mysql ‘retail_export’ database is not visible. But when I searched using ‘sqoop eval’, it is visible.