如何捕获在Windows服务器上安装的MySQL服务器上触发的连接的IP /位置和查询 [英] How to capture connection's IP/Location and queries fired on MySQL server installed on windows server

问题描述

我的Windows服务器2008R2安装了MySQL服务器5.1.51。有人通过直接访问或通过远程访问来打开服务器，然后通过使用MySQL Query浏览器或使用shell登录到MySQL服务器，修改了某些数据库表中的数据。 Person未使用部署在服务器上的应用程序修改数据。我想创建一个记录日志，从哪个位置或IP连接建立以及触发了哪些查询。请给我一些解决方案或建议我如何实现这一目标？

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?

推荐答案

我会开始阅读： MySQL 5.0参考手册 - 5.2.2一般查询日志 [ ^ ]。

I would start reading this: MySQL 5.0 Reference Manual - 5.2.2 The General Query Log[^].

这篇关于如何捕获在Windows服务器上安装的MySQL服务器上触发的连接的IP /位置和查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！