Error while trying to grant privileges to Sqoop server on MySQL server


Error description:

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.

Error message

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 ?

1 Answer(s)


Hi Krishnan,

Thanks for the update. We have kept so that student using mysql 5 version won't face any issue which are major user.

Sorry for inconvenience. We will add as note with update command for only mysql 5.8 users.