Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I installed xampp on my Macbook a day before. It worked perfectly yesterday. But today when I try to start the phpmyadmin it gives the following error:

Can't create/write to file '/var/folders/Uu/UuhwtR9xE3Ozsao8ttdIWU+++TI/-Tmp-/#sql1b5_8_0.MYI' (Errcode: 13)

Can anybody tell the solution for this problem?

Thanks,
Madhup

share|improve this question
    
Is MySQL working? –  mibus Mar 13 '10 at 7:14
    
Yups... its working –  Madhup Mar 13 '10 at 8:32
    
That's particularly weird. I'm not familiar with XAMPP, but that looks like MySQL is trying to to table or index alterations into the given directory, and it either doesn't exist or it doesn't have correct permissions or available space. MySQL would be trying to put it in the same directory as the "real" tables, or in the nominated temporary directory. Check your config and filesystem layout? –  mibus Mar 15 '10 at 7:31
add comment

1 Answer

$ perror 13
OS error code  13:  Permission denied

MySQL is trying to create tmp tables and its now allowed to due to permissions

Try adding the following to your my.cnf and restarting

tmpdir = /tmp
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.