Reply
Explorer
Posts: 11
Registered: ‎06-06-2017
Accepted Solution

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

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

Highlighted
Posts: 1,565
Kudos: 287
Solutions: 239
Registered: ‎07-31-2013

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

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).
Backline Customer Operations Engineer
Announcements