Definitely don't give others permission to the /root directory. Try starting the server like this:
mysqld --tmpdir=/tmp If that works, then maybe you're putting you tmpdir line under the wrong group in the my.cnf file or it's being replaced elsewhere. On Fri, 2004-11-19 at 16:21, Gail Lange wrote: > Hello > 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]