Changing permissions on auditing files
After enabling auditing plugin, the log file owner is being 'mysql' if I set 'server_audit_output_type' variable to FILE. However, if I set 'server_audit_output_type' variable to SYSLOG, it's owner is being 'root'. Is there a way to identify any user as the owner of the log file instead of root or mysql? Thanks for your helping.
Answer Answered by Faustin Lammler in this comment.
Hi, thanks for your question.
Did you take a look at https://mariadb.com/kb/en/library/mariadb-audit-plugin-system-variables and https://mariadb.com/kb/en/library/configuring-mariadb-with-option-files/.
The last documentation will help you to configure mariadb server to run under another user (and log file owner).
BTW, can I ask you why you would change the owner of the log file?
Regards,
Faustin