C.5.3.1. Problems with File Permissions

If you have problems with file permissions, the UMASK environment variable might be set incorrectly when mysqld starts. For example, MySQL might issue the following error message when you create a table:

ERROR: Can't find file: 'path/with/filename.frm' (Errcode: 13)

The default UMASK value is 0660. You can change this behavior by starting mysqld_safe as follows:

shell> UMASK=384 # = 600 in octalshell> export UMASKshell> mysqld_safe
        &

By default, MySQL creates database directories with an access permission value of 0700. You can modify this behavior by setting the UMASK_DIR variable. If you set its value, new directories are created with the combined UMASK and UMASK_DIR values. For example, if you want to give group access to all new directories, you can do this:

shell> UMASK_DIR=504 # = 770 in octalshell> export UMASK_DIRshell> mysqld_safe
        &

MySQL assumes that the value for UMASK or UMASK_DIR is in octal if it starts with a zero.

See Section 2.12, "Environment Variables".