What steps would you perform to create a new audit file?

You are using the MySQL Enterprise Audit plug-in, and the audit.log file is corrupted. What steps would you perform to create a new audit file?

Question:

What steps would you perform to create a new audit file?

Options:

As the root user, execute the FLUSH AUDIT LOGS command. Refresh the audit plug-in with SET GLOBAL audit_log_status =REFRESH.

Stop the MySQL server. Move or rename the existing audit.log file. Restart the MySQL server.

Stop the MySQL server. Reinstall the audit plug-in by using INSTALL PLUGIN audit_log SONAME ‘audit_log.so’; Delete the corrupted file. Restart the MySQL server.

As the root user, execute the SET GLOBAL audit_log_flush=ON command.

Correct Answer

The Correct Answer for this Question is

Stop the MySQL server. Reinstall the audit plug-in by using INSTALL PLUGIN audit_log SONAME ‘audit_log.so’; Delete the corrupted file. Restart the MySQL server.