SQOOP - Access denied error

Hi ,

While performing import statement, i’m getting below error… Could you please help me to resolve.

[nagarajuonline@gw01 ~]$ sqoop import --connect jdbc:mysql://nn01/retail_db/ --table customers -m 1
Warning: /usr/hdp/ does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
17/07/12 05:15:33 INFO sqoop.Sqoop: Running Sqoop version:
17/07/12 05:15:33 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
17/07/12 05:15:33 INFO tool.CodeGenTool: Beginning code generation

17/07/12 05:15:34 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Access denied for user ‘’@‘gw01.itversity.com’ (using password: NO)
java.sql.SQLException: Access denied for user ‘’@‘gw01.itversity.com’ (using password: NO)

Thank you…


Seems like access issue buddy , try running in sudo mode , they should be giving you permissions soon if that is the issue, in your command you haven’t specified any password to connect to the database

if you have password use the following template

sqoop import
–connect jdbc:mysql://airawat-mySqlServer-node/employees
–username myUID
–password myPWD
–table employees
-m 1
–target-dir /user/airawat/sqoop-mysql/employees

Try JDBC url as follows:


You can just provide the username and password for the database retail_db