Can't create/write to file '/root/tmp/

[Patrick Farrell]

I just reinstalled Mandriva 2006 on a machine that was working great with 5.0.18-0.glibc23.i386.rpm and Connector/J
mysql-connector-java-3.1.13-bin.jar

So the next step was to get MySql all happy.
I downloaded and used urpmi to install
MySQL-server-5.0.22-0.i386.rpm and the related clients, etc.
and when I do, I can't do a simple 'desc table' command
from the shell client. It always gives a error like

mysql> desc watches;
ERROR 1 (HY000): Can't create/write to file '/root/tmp/#sql_7e51_0.MYI' (Errcode: 13)

But my 300+ class Java program works
great.

I have tried setting the
slave_load_tmpdir to a nice mysql writable directory
such as /var/lib/mysql/tmp and have chmod the
/root/tmp to 777 (only as a test)
seen that the only thing that contains the string
/root/tmp/ is the slave_load_tmpdir variable.

From the Mandrake mirrors, I see that the only MySql 5.0 is labeled '5.0.4-0.beta.1mdk' which is a pretty long ago version.

If I install it, then the mysql shell client works great, but
I get zillions of errors in my Java application.

Right now, the mysql user has a home directory of /var/lib/mysql
and that is where the datadir points, etc.

I know it is possible to get both the shell mysql client and the Connector/J to work. Clearly I'm doing something wrong. what settings do I need to change to make it happy?

Thanks
Pat



Edited 1 time(s). Last edit at 07/09/2006 03:16PM by Patrick Farrell.