Track MySQL operations records

Test environment inexplicably there are several important data is deleted, because in Binlog only see is the public account deleted, unable to query who is in which time period log in, consider how to record every MySQL account login information, in MySQL, Each connection executes the Init-connect first and the connection is initialized, where we can get the user's login name and thread ID value. Then with Binlog, we can track the operation time of each operation statement, the operator and the client's connection process information, etc. Implement audits.

See http://blog.csdn.net/bestone0213/article/details/44307267 and http://blog.csdn.net/yabingshi_tech/article/details/46548809 for details.

This article from the "Little Flash" blog, declined to reprint!

Track MySQL operations records