I'm working on importing data from MySQL to HDFS using Sqoop and following the instructions in Module 9. The error is in step 20, which is about granting privileges to Sqoop server (by which I mean, server in which Sqoop has to be run) on MySQL server.
mysql> grant all privileges on *.* to 'root'@’<IP address for VM>' IDENTIFIED BY 'cloudera' WITH GRANT OPTION;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'cloudera' WITH GRANT OPTION' at line 1
Could you please help me understand and rectify the error in syntax ?