Sqoop import errror: Access denied


#1
[kirantadisetti@gw02 lib]$  sqoop job -exec sqoop_incr_job

18/10/11 09:59:08 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.6.5.0-292
Enter password:
18/10/11 09:59:13 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
18/10/11 09:59:13 INFO tool.CodeGenTool: Beginning code generation
18/10/11 09:59:13 ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Access denied for user ‘retail_user’@‘149.56.27.98’ (using password: YES)
java.sql.SQLException: Access denied for user ‘retail_user’@‘149.56.27.98’ (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(Mys


#2

@Kiran_Tadisetti Can you share the sqoop job --create command which you tried?


#3

sqoop job --create sqoop_incr_job
– import
–connect jdbc:mysql://ms.itversity.com:3306/retail_db
–username retail_user
–password itversity
–table orders
–target-dir /user/kirantadisetti/sqoop_import/incr_order
–incremental append
–check-column order_id


#4

@Kiran_Tadisetti Enter password as itversity and let us know.