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]

Re: Query log for mySQL?

Kevin Thorpe:
[color=blue]
> 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).[/color]

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]

Re: Query log for mySQL?

André Næss wrote:[color=blue]
> Kevin Thorpe:
>
>[color=green]
>>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).[/color]
>
>
> A quick search for "logging" in the MySQL manual found me this:
> http://www.mysql.com/doc/en/Query_log.html[/color]

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@hotmail.com]

Re: Query log for mySQL?

On Wed, 26 Nov 2003 10:28:46 +0000, Kevin Thorpe <kevin@pricetra k.com>
wrote:
[color=blue]
>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).
>[/color]

http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Log_Files

Tom Lynn
--------

http://www.tomlynn.com