how to grant specific privileges when using sqoop import/export data from/to mysql

[#1]

HI,

When you submit a sqoop job, it will convert to MR job running in your cluster.

if the job need to access mysql . how to grant privileges to cluster?

means need grant privileges to each server in cluster one by one?

Thanks 

Harry

[#2 · Accepted solution]

Yes, that is right. In MySQL though, you can ease user access provisioning
by granting wildcard host login access, to allow all hosts:
https://dev.mysql.com/doc/refman/5.7/en/adding-users.html (look for the %
character example on page).