Percona and MySQL audit

Question

I am trying to audit MySQL commands for users on Percona. Current version of Percona is 55-5.5.22-rel25.2.237.rhel5.

The following URL gives guidance, however I do not know how to get it working.

http://www.percona.com/doc/percona-server/5.5/diagnostics/mysql_syslog.html

I attempted to add to /etc/my.cnf

[mysqld]
syslog

However I keep getting error messages starting.

130601 18:50:09 [ERROR] /usr/sbin/mysqld: unknown option '--syslog'

Anyone managed to get audit commands using that option?

Dennis Kaarsemaker · Accepted Answer · 2013-06-02T20:28:15.037

4

The syslog option goes in the [mysql] section, not in the [mysqld] section, it's only for the client, not the server.

So this does not provide any auditing of mysql commands, for that you need to enable query logging. For MySQL you'll find documentation here, I didn't find percona-specific documentation unfortunately.

edited Jun 02 '13 at 20:28

answered Jun 01 '13 at 11:58

Dennis Kaarsemaker

19,277
2
44
70

-1 : Sorry, `syslog` is not for `[mysqld]` or `[mysql]` – RolandoMySQLDBA Jun 02 '13 at 02:10
Read the link he posted. It may be percona specific, but it's definitely going in the [mysql] section. – Dennis Kaarsemaker Jun 02 '13 at 08:52
I stand corrected. Please edit your answer (change format, anything) so I can remove the downvote. – RolandoMySQLDBA Jun 02 '13 at 10:50
Done. Didn't know you can't remove a downvote without edit (not a heavy voter), that seems odd. – Dennis Kaarsemaker Jun 02 '13 at 20:28
Removed my downvote and upvoted you. Thanks for the reminder to keep current and thoroughly read the question. – RolandoMySQLDBA Jun 03 '13 at 10:46

Percona and MySQL audit

1 Answers1