开发者

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

开发者 https://www.devze.com 2023-03-09 03:06 出处:网络
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

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

精彩评论

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

关注公众号