Giving a normal user and Mysql access to a common directory
Posted
by
James R
on Server Fault
See other posts from Server Fault
or by James R
Published on 2012-12-11T02:00:08Z
Indexed on
2012/12/11
5:06 UTC
Read the original article
Hit count: 532
We need a common directory where Mysql can do a SELECT INTO OUTFILE and then the file can be picked up by a virtual server user in /home/theuser and worked on.
I can perform the SELECT INTO OUTFILE into the /tmp/ dir but theuser does not have access here. Would it be ok to grant the user access to tmp or is that bad practice?
The other option I looked at was creating a group 'theusermysql' containing the mysql user and theuser. I set the group on the tree /home/theuser/thedumpfolder and gave write permissions on thedumpfolder, but for some reason mysql still complains that it cannot write here.
I'm completely stumped! What would be the best practice way to have a common folder for these two users?
© Server Fault or respective owner