MySQL 8.0 Database Administrator — Question 130

Which three are requirements for a secure MySQL Server environment? (Choose three.)

Answer options

• A. Restrict the number of OS users that have access at the OS level.
• B. Ensure appropriate file system privileges for OS users and groups.
• C. Minimize the number of non-MySQL Server-related processes running on the server host.
• D. Encrypt the file system to avoid needing exact file-system permissions.
• E. Keep the entire software stack on one OS host.
• F. Run MySQL server as the root user to prevent incorrect sudo settings.

Correct answer: B, D, E

Explanation

Option B is correct because appropriate file system privileges are crucial for securing access to MySQL data. Option D is valid as encryption can protect data integrity and confidentiality, while option E emphasizes the importance of minimizing complexity by keeping the stack on one host. Options A, C, and F are not optimal practices as they do not directly contribute to a secure MySQL environment.