>From the Manual (21.11 Problems with File Permissions) By default MySQL will create database and RAID directories with permission type 0700. You can modify this behavior by setting the UMASK_DIR variable. If you set this, new directories are created with the combined UMASK and UMASK_DIR. For example, if you want to give group access to all new directories, you can do:
shell> UMASK_DIR=504 # = 770 in octal shell> export UMASK_DIR shell> /path/to/safe_mysqld & In MySQL Version 3.23.25 and above, MySQL assumes that the value for UMASK and UMASK_DIR is in octal if it starts with a zero. So either the dir has to be owned by the same user which runs mysqld .... or change the current directory permissions and the UMASK_DIR to prevent further issues. Regards, Dan > -----Original Message----- > From: Quentin Bennett [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 10 January 2002 8:27 a.m. > To: 'P.Agenbag'; mysql > Subject: RE: Error 13 > > > Hi > > Error 13 is from the OS - nothing to do with locks or whatever. > > However, when you add a new field (or change the table structure > in (nearly) > any way), mysqld will create a temporary table in the database directory - > are you sure that the permissions on the directory are correct? > > Remember, it is the user running mysqld that needs the > permissions, not the > user running the command. > > HTH > > Quentin > > -----Original Message----- > From: P.Agenbag [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 10 January 2002 6:14 a.m. > To: mysql > Subject: Error 13 > > > Hi > I have a table that I want to add a new field to while running on the > server, however, when I try to add a new field, it comes up with the > error13 message, saying it doesn't have permission, yet the files and > folder are all chmod 777. Can it be due to the fact that there is a > permanent connection to this table from another server and that mysql is > preventing any major changes? > Should I just try to make a copy of the table and make the changes to it > and then overwrite the old one? > > Is there a "cleaner way of managing your tables and to make changes > without having to resort to this "manual way"? > > Thanks > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > The information contained in this email is privileged and confidential > and intended for the addressee only. If you are not the intended > recipient, you are asked to respect that confidentiality and not > disclose, copy or make use of its contents. If received in error > you are asked to destroy this email and contact the sender immediately. > Your assistance is appreciated. > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
