Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Explorer

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

1 ACCEPTED SOLUTION

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

View solution in original post

1 REPLY 1

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