Can't create/write to file '/root/tmp/#sql_1570_0.MYI'

[baretto]

Hi,
I have installed XAMPP on /opt
It works, but often, some queries in web page and some operations via PhpMyAdmin do not work.
I get this error:

Code: Select all

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

What's this? How can I do?

[baretto]

up: someone can help me?

[Dave_L]

That looks like a permission error:

$ /opt/lampp/bin/perror 13
System error: 13 = Permission denied

But I don't understand why MySQL is trying to use the directory /root/tmp.

[baretto]

thanks
I have typed (as user):
/opt/lampp/bin/perror 13
and I get:
OS error code 13: Permission denied

But this error is alive: I can't work fine nor via phpMyAdmin nor in web pages...

how can I do?
there is some parameters to modify in order to resolve this problem?

[Dave_L]

Apparently MySQL is using the wrong tmp directory. I Googled for that error message, and saw some suggested solutions. The easiest one is to check /opt/lampp/etc/my.cnf, and verify that the following is present:

Code: Select all

[mysqld]
...
tmpdir = /tmp/

If you change that file (back it up first), you'll need to restart MySQL.