MySQL Workbench offers a GUI interface to the Audit Inspector.
The Audit Inspector interface was added in MySQL Workbench 6.0.0.
Initially, when you first load the Audit Inspector, you must use MySQL Workbench to cache the audit log for performance reasons. MySQL Workbench will then parse, index, and retrieve values from the encrypted cached file on your local computer. At this stage, you also set a password for the encrypted file that will be used when viewing this file. The initial screen looks similar to:
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.
After caching an audit log, the Audit Inspector page will display the results:
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.
You can Add Files to Cache from the main Audit Inspector page:
Future uses of the Audit Inspector will require the password that you set during the initial step. The login page:
Copyright © 2006, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices