Bug #2558 ERROR 1:Can't create/write to file '/root/tmp/#sql_1308_0.MYI' (Errcode: 13)
Submitted: 29 Jan 2004 8:54 Modified: 29 Feb 2004 12:03
Reporter: Cédric CHAUVRY Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:server-5.0.0-0.i386.rpm OS:Linux (Mandrake 10beta1)
Assigned to: CPU Architecture:Any

[29 Jan 2004 8:54] Cédric CHAUVRY 
Description:
bad tmp file config per default.

When the mysql server want create a tmp table ->

ERROR 1:Can't create/write to file '/root/tmp/#sql_1308_0.MYI' (Errcode: 13)

How to repeat:
do a request who must make a table tmp.
[29 Jan 2004 12:03] MySQL Verification Team 
are yoi using our binary ???

Our binary default settings are not as reported.

This could also be a consequence of the error in shell default environmental variables.
[14 Feb 2005 22:54] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[22 Mar 2006 2:21] tony z 
I had this same problem on Mandriva recent distribution. I just set a+rx to /root and a+rwx to /root/tmp and then I could get Health and Catalogs to work fine with MySQL Administrator. This was an easier solution (for me) than rejiggering the tmp dir environment variables.