MySQL Workbench offers a graphical interface to the Audit Inspector. By
audit_log plugin is not installed.
To activate the
Click Audit Inspector from the Administration secondary tab of the Navigator area to open the Administration - Audit Inspector tab.
Clickwithin the tab.
After the plugin is installed, the initial screen looks similar to the figure that follows. At this point, no entries are listed.
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 pressduring the caching process, MySQL Workbench saves the results that were cached at the point you pressed .
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 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.. When prompted, set a password for the encrypted file to use when viewing this file. After caching an audit log, the
The search field offers criteria for narrowing the displayed events, includingand , and defaults to . Custom filters are also available.
Clickat any time to add new files to the cache. Click to remove the cache file.
The next time you start the Audit Inspector, MySQL Workbench prompts you for the password that you set during the initial step.