nerdexam
Oracle

1Z0-883 · Question #25

Consider the MySQL Enterprise Audit plugin. On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin `audit_log' init function returned error. In the audit…

The correct answer is D. Move or rename the existing audit.log file. See the full explanation below for the reasoning.

Question

Consider the MySQL Enterprise Audit plugin. On attempting to start the MySQL service after a crash, notice the following error:

[ERROR] Plugin `audit_log' init function returned error. In the audit log file, you notice the final entry:

... <AUDIT_RECORD TIMESTAMP="2013-07-09T02:12:35" NAME="Connect" CONNECTION_ID="98" STATUS="0" USER="Kate" PRIV_USER="kate" OS_LOGIN="" HOST="localhost" DB=""/> What action should you take to fix the error and allow the service to start?

Options

  • ARe-install the audit plugin.
  • BExecute the command FLUSH LOGS.
  • CExecute the command SET GLOBAL audit_log_fiush= ON.
  • DMove or rename the existing audit.log file.

How the community answered

(25 responses)
  • A
    4% (1)
  • B
    8% (2)
  • C
    12% (3)
  • D
    76% (19)

Community Discussion

No community discussion yet for this question.

Full 1Z0-883 Practice