Description:
The server variables for audit plugin are displayed but can not be edited.
Some can be changed, some not:
audit_log_buffer_size can be edited but value is not stored.
audit_log_connection_policy can be edited but value is not stored.
audit_log_current_session: The value that is displayed is the global value. This one is not used by the plugin. The local value must be displayed.
audit_log_exclude_accounts can be edited but is not changed in the server although it is a dynamic variable.
...
audit_log_policy can be changed but results in an SQL error. The variable is no longer dynamic in versions >=5.6.21
How to repeat:
Connect with workbench to a MySQL 5.6.21 server, install and activate audit plugin. Try to modify values.
Suggested fix:
Workbench should allow editing for rw variables. This depends on the server release. It seems workbench has a wrong repository of server variables.
Workbench only displays global variables. audit_log_current_session is useless as a global variable. Either workbench displays the local value or omits this variable or the description string explains the issue with local/global.
