0

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?

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

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;
|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.