I have server database MySQL which is connected to different network(or ip address) i want to find out which user has updated what and when ?
can log file help me in this if so how ?
please can anyone update me in this?
You should activate the general log. Normally, the general is a text file. I have posts that show you how to make the general log a MyISAM table. Then, you could query the general log by datetime using SQL.
Here are my posts how to setup and configure the general log as a MyISAM table
Jun 30, 2011: How do I output MySQL logs to syslog?
Jan 08, 2012: How to enable MySQL general log?
Feb 11, 2012: MySQL general log
Apr 04, 2013: Stress test MySQL with queries captured with general log in MySQL
Jun 23, 2013: Analyse MySQL General Query Log in Real-time?
Apr 28, 2014: MySQL (on Windows) general log too large to rotate properly?
Once you configure it, just run queries like this to see commands run today
SELECT user_host,argument FROM mysql.general_log WHERE event_time >= DATE(NOW()) + INTERVAL 0 SECOND;