Tagged Questions
2
votes
2answers
74 views
Logging only mySQL logins on heavily used system
I have an audit requirement where they want all database access (logins) logged. We have a very large distributed system of hundreds of mySQL servers (shards, slaves, slaves of slaves) that are ...
0
votes
1answer
153 views
Saving every mysql user login attempts
Is there a way to save the username and the IP from which the user tries to login to a MySQL server??
Enabling general-log seems to log everything but that seems to write too much details taking more ...
0
votes
1answer
110 views
Reporting tools for MySQL Enterprise Audit Log
Oracle recently came out with the MySQL Enterprise Audit plugin.
However, currently there is no integration with their Audit Vault or DB Firewall products for robust filtering, reporting, etc. But ...
2
votes
1answer
348 views
How to speed up audit trigger?
The task: write a trigger to log all updates within tbl1 table for future audit users' actions.
The tbl1 table:
id INT(11)
y SMALLINT(6)
country SMALLINT(6)
-- really here ~20 fields but only some ...
8
votes
3answers
3k views
Audit logins on MySQL database
Is there a way to audit logins to MySQL? I'd like to be able to create a username for each employee and thereby create an audit trail of logins. However, googling has turned up no good results.
The ...
