MySQL Workbench Manual  /  Administrative Tasks  /  MySQL Audit Inspector Interface

6.6 MySQL Audit Inspector Interface

MySQL Workbench offers a graphical interface to the Audit Inspector. By default, the audit_log plugin is not installed.

To activate the audit_log plugin:

  1. Click Audit Inspector from the Administration secondary tab of the Navigator area to open the Administration - Audit Inspector tab

  2. Click Install audit_log within the tab.

After the plugin is installed, the initial screen looks similar to the figure that follows. At this point, no entries are listed.

Figure 6.24 Workbench: Audit Inspector: Initializing

Content is described in the surrounding text.

When you first start the Audit Inspector, MySQL Workbench must cache the audit log for performance reasons. MySQL Workbench then parses, indexes, and retrieves values from the encrypted cached file on your local computer.

Generating the cache file can take a long time. If you press Abort during the caching process, MySQL Workbench will save the results that were cached at the point you pressed Abort.

Note

MySQL Workbench will prompt for sudo access if the MySQL Workbench user is unable to read the audit log file.

To generate the cache file, click Cache Selected Files for Browsing. When prompted, set a password for the encrypted file that will be used when viewing this file. After caching an audit log, the Audit Inspector screen displays the results as shown in the following figure. Each record includes a record ID, timestamp, type, connection ID, user, host/IP, status, command class, and information.

Figure 6.25 Workbench: Audit Inspector

Content is described in the surrounding text.

The search field offers criteria for narrowing the displayed events, including Show events of type Fetch and Show events of type Query, and defaults to Show all events. Custom filters are also available.

Click Add Files to Cache at any time to add new files to the cache. Click Delete Cache to remove the cache file.

The next time you start the Audit Inspector, you will be prompted for the password that you set during the initial step.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.