From: Sachin Gaikwad (sachin.kernelgmail.com)
Date: Mon Oct 06 2008 - 14:01:04 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Thanks a bunch for the quick reply.
I will surely write a C program to read this logfile of general queries.
But before that I am not able to find this logfile for general queries.

I started my server like this:

$/etc/init.d/mysqld start --log=logfile --log-output=/tmp

Meaning log file will be in = /tmp/logfile

$mysql
mysql> select * from whowhatwhen;
xxxxxx
xxxxxxx
xxxx
xxxxx
mysql>

So this query should exist in logfile. But I am not able to see this
logfile in /tmp itself. What am I missing ?

Thanks,
Sachin

On Mon, Oct 6, 2008 at 2:29 PM, Weston, Craig (OFT)
<Craig.Westonoft.state.ny.us> wrote:
> This problem is Chapter 16.6 of The MYSQL Cookbook, (second edition)
> that has made my(sql) life much easier. You might want to look around
> at http://artfulsoftware.com/ which has lots of examples and a great
> e-book resource.
>
> Both of these are fantastic resources for me, and they are probably my
> most used books in my mysql library.
>
> Good luck,
>
> Craig
>
>
> --------------------------------------------------------
> This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.
>
>
> -----Original Message-----
>
> From: Sachin Gaikwad [mailto:sachin.kernelgmail.com]
> Sent: Monday, October 06, 2008 2:07 PM
> To: mysqllists.mysql.com
> Subject: Access Rights ?
>
> Hi all,
>
> I am newbie using MySQL. I want to log each client request to database
> server. I thought when server checks access rights of user(client)
> will be good place to "log" all "access/read/update" requests.
>
> If somebody knows where exactly this is done in source code, I will
> get a real kick start. Right now I am browsing through the source code
> through cscope to find out this.
>
> Any help in this regard is appreciated.
>
> Thanks,
> Sachin
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=craig.westonoft.state.ny.us
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]