3.1 Ensure 'datadir' Has Appropriate Permissions

Information

The data directory is the location of the MySQL databases.

Rationale:

Limiting the accessibility of these objects will protect the confidentiality, integrity, and availability of the MySQL database. If someone other than the MySQL user is allowed to read files from the data directory, it may be possible to read data from the mysql.user table which contains passwords. Additionally, the ability to create files can lead to denial of service, or might otherwise allow someone to gain access to specific data by manually creating a file with a view definition.

Solution

Execute the following commands at a terminal prompt:

chmod 750 <datadir>
chown mysql:mysql <datadir>

See Also

https://workbench.cisecurity.org/benchmarks/10139

Item Details

Category: ACCESS CONTROL

References: 800-53|AC-3, CSCv7|14.6

Plugin: MySQLDB

Control ID: adc5cba475ebdf4baaf2463edb468848c92a725353ed6ef096ad043e39b4dbfb