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) <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > Sent: Monday, October 06, 2008 2:07 PM > To: mysql@lists.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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
