Access denied for Sqoop

sqoop

#1

Hi Team,
I am unable to execute below command. Please advice.

[bhuvaneswar216@gw03 ~]$ sqoop import --connect jdbc:mysql://ms.itversity.com:3306/retail_db --username retailuser --password itversity --table orders --warehouse-dir /user/bhuvaneswar216 --compress --compression-codec snappy --as-avrodatafile -m 1
Warning: /usr/hdp/2.5.0.0-1245/accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
18/07/16 20:25:26 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.5.0.0-1245
18/07/16 20:25:26 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
18/07/16 20:25:26 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
18/07/16 20:25:26 INFO tool.CodeGenTool: Beginning code generation
18/07/16 20:25:26 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Access denied for user ‘retailuser’@‘gw03.itversity.com’ (using password: YES)


#2

try retail_user instead of retailuser