[mythtv-users] HELP: No temp tables permissions: SOLVED, not understood

[David Brodbeck]

On Nov 19, 2007, at 4:24 AM, R. G. Newbury wrote:
> The problem was/is with /tmp. Two questions remain...1) Why putting
> 'TMPDIR=/tmp/mysql' into my.cnf did NOT cause mysql to put temp files
> into that directory; and 2) Why mysql would not use /tmp owned by  
> root,
> but permissioned as 777, but would use it when chowned to mysql:mysql.
> (Working as the latter makes sense, but not working when /tmp is owned
> by root does not...).
>
> But it IS working now, and I don't care that mysql owns /tmp...  
> This IS
> a mythbox after all and doesn't have any other users..or uses!.

What happens if you leave /tmp owned by root, but make the /tmp/mysql  
subdirectory owned by MySQL?