To check who has updated my database

Question

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?

Answer 1

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;