-
MySQL access log
Hi guys,
I am a beginner here and I am asking for your help. I have an application running with MySQL 4.0.13. I want have a daily log showing all the users which accessed the documents stored in the DB, their IP, date and time of the access, the name of the document accessed,etc. I want to get a log similar in structure with the one created by the Microsoft IIS FTP server. How can this be done?
PS: I forgot to mention, my OS is Windows XP with SP2.
Thank you.
Last edited by pamelu; 01-24-2005 at 01:34 AM.
-
Linux ?
Edit /etc/my.cnf
Add the line below under section [mysqld]
log=/var/log/mysqld.log
(change the location as your wish )
touch /var/log/mysqld.log
chown mysql:mysql /var/log/mysqld.log
service mysqld restart
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|