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

[Michael T. Dean]

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!*.

http://dev.mysql.com/doc/refman/4.1/en/installing-binary.html

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
mysql.
http://dev.mysql.com/doc/refman/4.1/en/problems-with-mysql-sock.html

Mike