Do you have more than one configuration file? Do you have a my.cnf in /etc directory and others in /root or in the home directory of the user mysql which is starting MySQL? Still, the command-line should override the my.cnf settings.
On Fri, 2004-11-19 at 17:31, Gail Lange wrote: > Hello Spenser > Actually, I did the following command: > mysqld_safe --user=mysql --tmpdir=/tmp > and still got that error message. My understanding is that mysqld_safe > is just a wrapper > for mysqld. > Gail > > Spenser wrote: > > 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]