2

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?

Improve this question

1 Answer 1

Reset to default
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.

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

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.