mysql cant create/write to file /tmp

2 posts / 0 new
Topic locked
Last post
#1 Tue, 01/23/2007 - 18:01
gmcnickle

mysql cant create/write to file /tmp

I recently secured my /tmp partition, and now I get an error when I try to view the user permissions in mysql from the webmin panel. The exact error is:

SQL desc user failed : Can't create/write to file '/tmp/#sql_331d_0.MYI' (Errcode: 13)

any idea how to get around this?

Thu, 01/25/2007 - 04:00
sgrayban

/tmp requires 777 permissions

If you want to secure it use:
/dev/hdd7 /tmp ext3 noexec,nosuid 0 0

in your fstab -- make sure you use the right dev and not mine.

Topic locked