MySQL SELECT - OUTFILE permissions prob.

[Anon]

I am having a bit of a problem with one aspect of mySQL. Basically, I'm trying to do a SELECT into OUTFILE command. mySQL won't let me write the outfile to the user's home directory (i.e. /home/user/domain/outfile.txt) saying that it isn't allowed to create/write etc. to this directory. It works when I write to something like /tmp or anything not in the home directory. Is this a permissions issue that I have to set in the mySQL grant table? Would appreciate any help on this...

thanks!
-Zac
mySQL newbie