Apache Friends Support Forum

I have XAMPP set up on a mandriva 2006 installation.
I have installed it fine but i have a problem that when i go into phpmyadmin and look at a table is gives the following error:

Error

SQL query: Edit

SHOW FULL FIELDS FROM `customers` ;

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

Anyone got any ideas, becuase we really are in tears over this

Dear cs02sc!

Did you made any changes to /opt/lampp/etc/my.cnf?

Greetings
Oswald

No should I have?

Dear cs02sc!

Good. Please call the following two commands:

echo $TMPDIR
echo $TMP

What output do you get?

Greetings
Oswald

for both of them i get

"root/tmp"

is this correct?

Dear cs02sc!

That's the problem. In this case please edit /opt/lampp/etc/my.cnf and search for this line:

#tmpdir = /tmp/

Now, remove the # in front of the line:

tmpdir = /tmp/

Restart XAMPP and everything should work now.

Greetings and good luck
Oswald

it works

I love you very much