开发者

Access history report for MySQL - knowing who accessed the database and when

I was wondering if the is a way or tool that will enable me to have access history/report to my开发者_StackOverflow MySQL database (I have no root/shell access on the server). I would like to be able to know when and what user accessed the database, and which table, if possible.

Thanks!


The mysql general query log is used for this but you need access to the server and database to enable it. Be aware, even with connections logged like this, if requests are made from scripts on the server, I ain't sure this will give you the ip as the request is made from localhost.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜