MySQL Error : Can't create/write to file '/var/mysqltmp/#sql_1fbd_0.MYI' (Errcode: 13)

Question

yesterday i got bad getway error while browsing my vb forum

and today my forum back to work ... but most of links give this error

MySQL Error   : Can't create/write to file '/var/mysqltmp/#sql_1fbd_0.MYI' (Errcode: 13)

i search for simillar problem and got that this is premission problem

using FTP account i didnt found this directory "var/mysqltmp" so i made it and set premission to 777

but problem not solved

i read that this must fixed using Shell SSH ... but i didnt found a good explain about hoe to use shell SSH , because im Win Xp user :(

does this problem can be solved from FTP or Cpanel ? or its a server problem ?

thanks for help in advance

Solution

It looks like your permissions on /tmp are wrong. They really should be read/write/execute for everyone with the sticky bit set.

chmod 1777 /tmp

The sticky bit add some restrictions to how other users interact with files not created or owned by them, so there's no reason to worry.

If you wish, you may also create a seperate directory owned and writeable by the mysql user and specify that directory in my.cnf to be used instead of the system wide /tmp.