Im running an Apache web server with MySQL on a Mandriva 2006 machine.
Im using phpmyadmin to make the database. I can create tables within the database fine. Problem is when i go to the table i have created it comes it with an error and wont display it. This is the error i get:


SQL query: Edit


MySQL said: Documentation
#1 - Can't create/write to file '/root/tmp/#sql_2c9c_0.MYI' (Errcode: 13)

I have found a website ( which suggests how to fix this problem in windows, but i cant find any clues as to how this is done on linux. Anyone got any ideas?