Sqoop getting error while connecting to MySQL

Question

I am trying to import a MySQL table using Sqoop but it is not happening. When I run the following command:

sqoop import --connect jdbc:mysql://localhost/retail_db --username hduser --table order

I get the following error:

ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Access denied for user 'hduser'@'localhost' (using password: NO)

Answer 1

Have you set a password for MySQL? Seems like it is password set but in your command, you have not mentioned any password. Try importing with password:

sqoop import --connect jdbc:mysql://localhost/retail_db --username --password <your password> hduser --table order