3.1 Ensure 'datadir' Has Appropriate Permissions and Ownership

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

Information

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 he or she might be able 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 700 <datadir> chown mysql:mysql <datadir>

See Also

https://workbench.cisecurity.org/files/1619