Re: error starting mysql 4.1.7 cannot create/write to /root/tmp
Hello. You may specify location of temp files with 'tmpdir' server system variable. See: http://dev.mysql.com/doc/mysql/en/Temporary_files.html http://dev.mysql.com/doc/mysql/en/Server_system_variables.html Gail Lange [EMAIL PROTECTED] 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) r permission to /root and rw permissions to /root/tmp, it start up fine. I have looked as startup options for the mysqld_safe as well as the /etc/my.cnf file but have not found anyway to alter where it wants to write its temp files. Can anyone please help? Thanks, Gail -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: error starting mysql 4.1.7 cannot create/write to /root/tmp
perror 13 System error: 13 = Permission denied The mysql user cannot read the /root filesystem. DVP Dathan Vance Pattishall http://www.friendster.com -Original Message- From: Gail Lange [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 10:23 AM To: [EMAIL PROTECTED] Subject: error starting mysql 4.1.7 cannot create/write to /root/tmp 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) r permission to /root and rw permissions to /root/tmp, it start up fine. I have looked as startup options for the mysqld_safe as well as the /etc/my.cnf file but have not found anyway to alter where it wants to write its temp files. Can anyone please help? Thanks, Gail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]