@Manoj690    Looks like your previous error is resolved.   For the new error better you shoudl have opened a new thread to avoid confusion for other readers of the thread.   I see the new error is HDFS related (and completely unrelated to Mysql related error which you originally reported to this thread)   19/08/28 18:06:43 ERROR tool.ImportTool: Import failed: org.apache.hadoop.security.AccessControlException: Permission denied: user=gaian, access=WRITE, inode="/user":hdfs:hdfs:drwxr-xr-x     For the HDFS error you will need to make sure that the user  "gaian" who is running the sqoop job does not have thw write permission on . "/user" directory. You might be able fix it by doing this:     # su - hdfs # hdfs dfs -mkdir /user/gaian # hdfs dfs -chown -R gaian:hadoop /user/gaian # hdfs dfs -chmod -R 755 /user/gaian   . If your question is answered then, Please make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button. ... View more

@Manoj690    As i mentioned in the other thread opened by you for the similar error. https://community.cloudera.com/t5/Support-Questions/Sqoop-jdbc-error/m-p/269108#M206636     As your latest error is    ERROR manager.SqlManager: Error executing statement: java.sql.SQLException: Access denied for user 'ambari1'@'localhost' (using password: NO)   . Which means you will need to make sure  following 2 things: 1. First thing is that you are entering correct password for "ambari1"  user in the sqoop command . using "--password" option. 2.  Also make sure to add the Grant as following for the root user in MySQL DB so that it can connect to mysql from the host where you are running the sqoop command. Example:   mysql> GRANT ALL PRIVILEGES ON *.* TO 'ambari1'@'localhost' IDENTIFIED BY 'XXXXXXXXXX' WITH GRANT OPTION; mysql> FLUSH PRIVILEGES;   Please replace the "XXXXXXXXXX' in the above command with your ambari1 password.   Please share the output of the following command shows the entry for 'amabri1' user with host 'localhost'   # mysql -u root -p Enter Password: <YOUR_PASSWORD> mysql> use mysql; mysql> select user, host FROM user;     ... View more