Description:
http://dev.mysql.com/doc/mysql-utilities/1.5/en/mysqlauditadmin.html
shows sample for policy --value=QUERIES
starting 'To change the audit log policy to log only query events, and show the system variables before and after the execution of the policy command, use the following command: '
But it's result based on MySQL 5.6.19 or before. so Add Note before a sample.
[MySQL 5.6.19 or before]
shell> mysqlauditadmin --show-options --server=root@localhost:3310 policy \
--value=QUERIES
How to repeat:
See
http://dev.mysql.com/doc/mysql-utilities/1.5/en/mysqlauditadmin.html
Suggested fix:
(1) Add Note to existed sample, like below.
[MySQL 5.6.19 or before]
shell> mysqlauditadmin --show-options --server=root@localhost:3310 policy \
--value=QUERIES
(2) And should add sample on new environment, like below.
[MySQL 5.6.20 or later]
shell> mysqlauditadmin --show-options --server=root@localhost:3310 policy \
--value=QUERIES
#
# Showing options before command.
#
# Audit Log Variables and Options
#
+-----------------------------+--------------+
| Variable_name | Value |
+-----------------------------+--------------+
| audit_log_buffer_size | 1048576 |
| audit_log_connection_policy | ALL |
| audit_log_current_session | OFF |
| audit_log_exclude_accounts | |
| audit_log_file | audit.log |
| audit_log_flush | OFF |
| audit_log_format | OLD |
| audit_log_include_accounts | |
| audit_log_policy | ALL |
| audit_log_rotate_on_size | 0 |
| audit_log_statement_policy | ALL |
| audit_log_strategy | ASYNCHRONOUS |
+-----------------------------+--------------+
#
# Executing POLICY command.
#
#
# Showing options after command.
#
# Audit Log Variables and Options
#
+-----------------------------+--------------+
| Variable_name | Value |
+-----------------------------+--------------+
| audit_log_buffer_size | 1048576 |
| audit_log_connection_policy | NONE |<-Changed
| audit_log_current_session | OFF |
| audit_log_exclude_accounts | |
| audit_log_file | audit.log |
| audit_log_flush | OFF |
| audit_log_format | OLD |
| audit_log_include_accounts | |
| audit_log_policy | ALL |<-Not changed (READ ONLY)
| audit_log_rotate_on_size | 0 |
| audit_log_statement_policy | ALL |
| audit_log_strategy | ASYNCHRONOUS |
+-----------------------------+--------------+
