Hi Sachin,
MySQL is capable of logging all queries to a log file, see
http://dev.mysql.com/doc/refman/5.0/en/query-log.html. This includes
connections, disconnections and executed SQL statements - no coding needed!
If you want this information imported into a database table, a couple of
hours and a few cups of coffee will allow you to write a simple PHP
script (or C program for the hard-core developers) to read this file and
write the details of each record to a database table.
Regards,
Andy
Sachin Gaikwad wrote:
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]