I think moving tmpdir to /var/tmp/mysql is fine (though remember /var/tmp is not automatically cleaned). This directory would then not be sticky and lack world writes? Would it also be 0700? If it is 0755 then mysql's umask should be 077.
I think moving tmpdir to /var/tmp/mysql is fine (though remember /var/tmp is not automatically cleaned). This directory would then not be sticky and lack world writes? Would it also be 0700? If it is 0755 then mysql's umask should be 077.