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:

Error

SQL query: Edit

SHOW FULL FIELDS FROM `customers` ;

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

I have found a website (http://dev.mysql.com/doc/refman/5.0/...ot-create.html) 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?