Audit - Log
Hi, After reading about the audit log (http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:95588), which I need; I looked for the my.cnf and mysql.log file but didn't find any nor any other related file. Are these created by default or should I create them ? Please advise. TIA. Jorge Ceballos Mexico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Audit - Log
You will need to create my.cnf and turn ON the loggin option. Bhavin. - Original Message - From: Jorge Ceballos [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 04, 2002 12:30 PM Subject: Audit - Log Hi, After reading about the audit log (http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:95588), which I need; I looked for the my.cnf and mysql.log file but didn't find any nor any other related file. Are these created by default or should I create them ? Please advise. TIA. Jorge Ceballos Mexico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Audit - Log
Hi, I've installed MySql on a RedHat box and configured log-bin. Everything is running OK. My question is, if a user does any insert, delete or update, can I see which user (username) has performed that action? Where can I log this information and retrieve it later, for auditing purposes? Thanks Frederico Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Audit - Log
Yes you can.. We have a log called mysql.log that has user@IP/domain and then the question. All you need to do is edit my.cnf to make shore it is on. We keep all the logs can just gunzip them up.all you need is a perl script to get the data back out. Simon -Original Message- From: Frederico Martins [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 16:17 To: '[EMAIL PROTECTED]' Subject: Audit - Log Hi, I've installed MySql on a RedHat box and configured log-bin. Everything is running OK. My question is, if a user does any insert, delete or update, can I see which user (username) has performed that action? Where can I log this information and retrieve it later, for auditing purposes? Thanks Frederico Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
