Query log for mySQL?

[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).

[André Næss]

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

[Kevin Thorpe]

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.

[tomlynn97]

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