I know that I can use ONESEC to e-mail myself if someone logs into my server but I was wondering if I could do the same thing if someone logs into a specific user for MySQL. My GoogleFu seems to be failing on this one.
1
-
1You can easily set up triggers in MySQL to update a logon history table fromdual.com/mysql-logon-and-logoff-trigger-for-auditing and possibly even use the OSSec database itself– HBruijnOct 9, 2014 at 6:09
Add a comment
|
1 Answer
I would setup MySQL to log to syslog and configure nowadzys versatiles syslog daemon (eg rsyslogd) to trigger an email when it matcha mysql log message that matches the appropriate pattern.
