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

[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:
> [url]http://www.mysql.com/doc/en/Query_log.html[/url]

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.

[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:
[url]http://www.mysql.com/doc/en/Query_log.html[/url]

André Næss

[tomlynn97@hotmail.com]

On Wed, 26 Nov 2003 10:28:46 +0000, Kevin Thorpe <kevin@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).
>

[url]http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Log_File s[/url]



Tom Lynn
--------
[url]http://www.tomlynn.com[/url]