By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 1,873 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

Query log for mySQL?

P: n/a
Is there a simple way to create a query log for mySQL? I've been
asked^h^h^h^h^h told to add a layer of auditing on an existing
application. It's unlikely that this audit log will ever be looked at so
a listing of sql queries would probably suffice (it'll be big enough to
impress anyway).
Jul 17 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Kevin Thorpe:
Is there a simple way to create a query log for mySQL? I've been
asked^h^h^h^h^h told to add a layer of auditing on an existing
application. It's unlikely that this audit log will ever be looked at so
a listing of sql queries would probably suffice (it'll be big enough to
impress anyway).


A quick search for "logging" in the MySQL manual found me this:
http://www.mysql.com/doc/en/Query_log.html

André Nęss
Jul 17 '05 #2

P: n/a
André Nęss wrote:
Kevin Thorpe:

Is there a simple way to create a query log for mySQL? I've been
asked^h^h^h^h^h told to add a layer of auditing on an existing
application. It's unlikely that this audit log will ever be looked at so
a listing of sql queries would probably suffice (it'll be big enough to
impress anyway).

A quick search for "logging" in the MySQL manual found me this:
http://www.mysql.com/doc/en/Query_log.html


So why didn't I try that? I can only blame trying to do ten things at
once and a major hangover. Shame it doesn't use syslog though.

Jul 17 '05 #3

P: n/a
On Wed, 26 Nov 2003 10:28:46 +0000, Kevin Thorpe <ke***@pricetrak.com>
wrote:
Is there a simple way to create a query log for mySQL? I've been
asked^h^h^h^h^h told to add a layer of auditing on an existing
application. It's unlikely that this audit log will ever be looked at so
a listing of sql queries would probably suffice (it'll be big enough to
impress anyway).


http://www.mysql.com/documentation/m...html#Log_Files

Tom Lynn
--------
http://www.tomlynn.com
Jul 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.