Tips and Tricks

The value specified for the --query-type option are case insensitive, therefore you can mix lower and upper case to specify the list of query types. For example, 'insert,Update' will produce the same result as using 'INSERT,UPDATE'. Of course the use of non-supported values will raise an appropriate error.

Many other options and search criteria are provided by the mysqlauditgrep utility, check them in order to use the more appropriate one to meet your needs. Note that the utility provides the --pattern option to search entries in the audit log file using regular expressions, like common grep tools. By default, this option will use standard SQL pattern matching (used by 'LIKE' comparison operator), unless the --regexp option is used to allow more powerful standard regular expressions (POSIX extended).

User Comments
Sign Up Login You must be logged in to post a comment.