MySQL 8.0 Database Administrator — Question 76

On examination, your MySQL installation datadir has become recursively world read/write/executable.
What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

Answer options

• A. Users could overwrite configuration files.
• B. Data files could be deleted.
• C. SQL injections could be used to insert bad data into the database.
• D. MySQL binaries could be damaged, deleted, or altered.
• E. Extra startup time would be required for the MySQL server to reset the privileges.

Correct answer: B, E

Explanation

The correct answer includes B and E because with improper permissions, data files can be deleted, which poses a significant risk to data integrity. Additionally, if the server has to reset permissions on startup, it can lead to increased startup time. Options A, C, and D are concerns but do not directly relate to the implications of world read/write/executable permissions on the datadir.