Support Questions

Find answers, ask questions, and share your expertise

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

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

Master Guru
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

Master Guru
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).
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.