mercredi 11 mars 2015

MySQL Data User Ownership


Which OS User will own MySQL Datafiles?


For example:


If i run the next command:


create database test;


It creates a folder on the datadir. Is there a variable that controls the ownership and permissions of that folder?


I know that you can control the user thar will run mysqld daemon by specifying user=username on my.cnf . The files created by mysqld daemon will be owned by that specified user? Or how it works?


"Also, the default permissions for directories inside the mysql data directory:


755 (rwxr-xr-x) for mysql top data directory 700 (rwx------) for each database directory 660 (rw-rw----) for database files" - http://ift.tt/1B5s5Vk





Aucun commentaire:

Enregistrer un commentaire