|
|
By default, MySQL runs as its own user on Unix. The user and group are mysql. Never be tempted to allow anyone access to the system as the mysql user—it should only be for the database itself. MySQL also creates a separate directory where it places data files. This directory is accessible only to the mysql user. The default settings have been chosen for a reason; keep to these principles:
Separate the data directory.
Secure the data directory (no one else should be able to read, much less write, in the MySQL data directory).
Run MySQL as its own user.
|
|