I have just installed mysql 4.1.7 on Mandrake 10.0 (final).
All went smoothly.
However, when I issue the following command:
/usr/local/mysql/bin/mysqld_safe --user=mysql &
I get the error:
Can't create/write to file /root/tmp/ibLmfg7w (Errcode: 13)
When I examine the error file in /usr/local/mysql/var it says it cannto read /root and it
cannot write to /root/tmp
If I give others (beside root) permission to /root and rw permissions to /root/tmp,
it starts up fine.
I got advice to look over specifying location of temp files with 'tmpdir' server system variable.
in:
http://dev.mysql.com/doc/mysql/en/Temporary_files.html
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
So I tried this advice by putting the following line In /etc/my.cnf in the [mysqld] section:
tmpdir = /usr
However, it still wants to write to /root/tmp at startup with a strangely named file (the filename changes with each startup).
I have done mysqladmin variables and nothing is listed as related to /root/tmp.
Is there some startup variable that I am missing?
Thanks,
Gail
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
