More on this: I set following in /etc/my.cnf:
log = FILE, TABLE after this I am not able to start my mysqld, it fails with timeout error message "Timeout error occurred trying to start MySQL Daemon." Thanks, Sachin On Mon, Oct 6, 2008 at 3:01 PM, Sachin Gaikwad <[EMAIL PROTECTED]> wrote: > 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]