[mythtv-users] HELP: No temp tables permissions: SOLVED, not understood
R. G. Newbury
newbury at mandamus.org
Mon Nov 19 12:24:00 UTC 2007
Michael T. Dean wrote:
> On 11/17/2007 12:28 AM, R. G. Newbury wrote:
>> I gave the /tmp directory to mysql:mysql from root and set permissions
>> to 777...(yup, brute force!)
>> AND THAT WORKED...
>> Why it would not work as root:root with 777 I have no idea. Why it
>> changed and stopped working from the prior state I have no idea.
>> And the temp directories which are created in /tmp *are owned by root!*.
> look at 7 and 8 and the file scripts/mysql_install_db.sh .
> I'm also guessing that /tmp needs to be 1777 (not 777) if not owned by
The problem is not with the /var/lib/mysql directory tree. It is all
owned by mysql as required.
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!.
More information about the mythtv-users