question how to grant specific privileges when using sqoop import/export data from/to mysql in Archives of Support Questions (Read Only)

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

Harry — Fri, 16 Sep 2022 12:30:38 GMT

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

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

Harsh J — Mon, 13 Nov 2017 01:33:37 GMT

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).