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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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;