是否在MySQL中记录超级用户登录？

Question

如何在MySQL中审核(记录)超级用户登录？

我已经使用触发器，根据http://www.fromdual.com/mysql-logon-and-logoff-trigger-for-auditing#comment-917这个链接，它只适用于登录除了init_connect variable.But中的超级用户，我需要记录超级用户登录时间与ip?任何人尝试过它，请帮助我找到和任何其他原因，超级用户将不登录init_connect变量？

Answer 1

您可以安装MySQL插件audit_login，它将报告您需要的内容，如下所示

{"ts":"2013-09-11 09:11:47","type":"successful_login","myhost":"gromit03","thread":"74153868","user":"web_user","priv_user":"web_user","host":"web-87.localdomain","ip":"10.0.0.87"}
{"ts":"2013-09-11 09:11:55","type":"failed_login","myhost":"gromit03","thread":"74153869","user":"backup_user","priv_user":"","host":"web-32","ip":"10.0.0.32"}