mariadb audit

1. howto

mariadb -u root -pPassw0rd -e "set global general_log=on;"

mariadb -u root -pPassw0rd -e "show variables like '%general_log%';"

+-----------------------------------------+------------------------------
| Variable_name                           | Value                                                                                                                                |
+-----------------------------------------+------------------------------
| general_log                             | ON                                                                                                                                   |
| general_log_file                        | /var/log/mariadb/audit.log                                                                                                           |
+-----------------------------------------+------------------------------

mariadb -u root -pPassw0rd -e "set global general_log=off;"

mariadb -u root -pPassw0rd -e "show variables like '%general_log%';"

+-----------------------------------------+------------------------------
| Variable_name                           | Value                                                                                                                                |
+-----------------------------------------+------------------------------
| general_log                             | OFF                                                                                                                                   |
| general_log_file                        | /var/log/mariadb/audit.log                                                                                                           |
+-----------------------------------------+------------------------------