MySQL Forums
Forum List  »  Install & Repo

Can't create/write to file '/root/tmp/
Posted by: Patrick Farrell
Date: July 07, 2006 09:55PM

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

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

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?


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

Options: ReplyQuote

Written By
Can't create/write to file '/root/tmp/
July 07, 2006 09:55PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.