MySQL 8.0 Database Administrator — Question 122

Which command enables rule-based MySQL Auditing capabilities?

Answer options

• A. shell> mysql < audit_log_filter_linux_install.sql
• B. shell> mysqld --initialize --log-raw=audit.log
• C. mysql> INSTALL PLUGIN audit_log;
• D. mysql> INSTALL COMPONENT audit_log;

Correct answer: A

Explanation

The correct answer is A because this command specifically executes a script that configures the auditing filter for MySQL. The other options do not directly enable rule-based auditing; option B initializes the MySQL server with logging, while options C and D deal with installing plugins or components rather than setting up the audit filter.