Unable to run import script using sqoop

Question

Please see the attached screenshot. I am unable to run import script using sqoop in hdfs. When I tried to import a table named PARTITIONS from the database information_schema, It is showing error. Please help.
Thanks

Answer 1

You are writing incorrect command. Please write below command:

grant all privileges on *.* to root@localhost IDENTIFIED BY 'root' WITH GRANT OPTION;

Also, you are writing this command in the terminal, not in MySQL window.  So, first, log in to MySQL and then write the command mentioned above.