MySQL

Security

When you run a MySQL installation, it's important to make sure that the data your users are storing is kept secure. The MySQL administrator is responsible for controlling access to the data directory and the server, and should understand the following issues:

• File system security. A UNIX machine may host several user accounts that have no MySQL-related administrative duties. It's important to ensure that these accounts have no access to the data directory. This prevents them from compromising data on a file system level by copying database tables or removing them, or by being able to read log files that may contain sensitive information. You should know how to set up a UNIX user account for the MySQL server, how to set up the data directory ...