Specifying Permissions for Schema (Data) Directories and Tables
By default MariaDB uses the following modes for creating directories and files.
| Mode for | Default Mode | Environment variable |
|---|---|---|
| Files | 0660 (same as -rw-rw----) | UMASK |
| Directories | 0700 (same as drwx------) | UMASK_DIR |
By setting the environment variables before you start mysqld or mysqld_safe you can specify the mode for files and directories.
Note that the environment variables are modes specified in octal and OR:de with the default value (as the default value is the minimum value needed for mysqld to work).
In other words, if you would run the following in the shell:
set UMASK=001 export UMASK
mysqld would use the mode 0661 when creating new files.
If you start the server with systemctl:
Execute
systemctl edit mariadb
An editor opens.
This creates a file named override.conf in the directory /etc/systemd/system/mariadb.service.d/
Write the desired value in the editor.
[Service] Environment="UMASK_DIR=0750"
After saving this file, you need to reload the service definitions before the changes will be recognized by MariaDB, thus:
systemctl daemon-reload systemctl restart mariadb
