Access denied while importing from sqoop....


1 Answer(s)


Hi Kumar,

The current syntax for grant permission is :

mysql> grant all privileges on *.* to 'root'@'192.168.164.128' IDENTIFIED BY 'password' WITH GRANT OPTION

If you want to grant permission from Mysql(windows) to hdfs(linux):

mysql> grant all privileges on *.* to 'root'@'192.168.164.1' IDENTIFIED BY 'password' WITH GRANT OPTION

If your mysql doesn't have password, please create a password and try again.

Access denied for user ''@'DESKTOP-SQ461J6' (using password: NO)

Hope this helps.

Thanks.