Click here to Skip to main content
15,867,488 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
My Windows server 2008R2 has MySQL server 5.1.51 installed. Somebody opened the server either by direct access or by taking it on remote, then person logged in to MySQL server either by using MySQL Query browser or by using shell, modified the data in some database tables. Person did not modified the data using application deployed on the server. I want to create a log to record, from which location or IP connection was established and what queries were fired. Please provide me some solution or advise me how can I achieve this?
Posted

1 solution

 
Share this answer
 
Comments
Pankaj Kumar 8-Sep-15 5:16am    
Thanks @CPallini for answering. General Query Log records select statements also, increasing its size faster. I tried Binary Log also, it records all queries except select statements. But the problem is, it does not record connection details. Is it possible to customize binary log to record connection details also?
CPallini 8-Sep-15 5:26am    
I really don't know, however, luckily, the documentation is available.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900