HengWang/mysql-audit

今天药忘吃喽~ 2022-08-23 11:55 144阅读 0赞

本文转载自：**https://github.com/HengWang/mysql-audit**

# [HengWang][]/**[mysql-audit][]** ![octocat-spinner-32.gif][] #

*  [Code ![octocat-spinner-32.gif][] ][mysql-audit]
 *  [Issues 1![octocat-spinner-32.gif][] ][Issues 1_octocat-spinner-32.gif_]
 *  [Pull Requests 0![octocat-spinner-32.gif][] ][Pull Requests 0_octocat-spinner-32.gif_]

*  [Pulse ![octocat-spinner-32.gif][] ][Pulse _octocat-spinner-32.gif_]
 *  [Graphs ![octocat-spinner-32.gif][] ][Graphs _octocat-spinner-32.gif_]
 *  [Network ![octocat-spinner-32.gif][] ][Network _octocat-spinner-32.gif_]

### **HTTPS** clone URL ###

### **Subversion** checkout URL ###

You can clone with [ HTTPS][HTTPS] or [ Subversion][HTTPS]. [ ][Link 1]

[Clone in Desktop ][Clone in Desktop] [Download ZIP ][Download ZIP]

mysql audit 2.2

*  [10 commits ][10 commits]
 *  [2 branches ][2 branches]
 *  [0 releases ][0 releases]
 *  [1 contributor ][1 contributor]

1.  [C 52.2% ][C 52.2_]
2.  [C++ 44.1% ][C_ 44.1_]
3.  [Shell 3.7% ][Shell 3.7_]

[CC++Shell ][HTTPS]

*branch:* master

Switch branches/tags

*  [Branches][HTTPS]
 *  [Tags][HTTPS]

[master][]

[version-3.0][]

Nothing to show

[mysql-audit][]  /

[Add variables checking whether is NULL or not][]

[ latest commit 1b3449f953][Add variables checking whether is NULL or not]

![Heng Wang][] [HengWang][] authored on Oct 31 2012

<table> 
 <tbody> 
 <tr> 
 <td><img width="16" height="16" alt="" src="https://assets-cdn.github.com/images/spinners/octocat-spinner-32.gif"></td> 
 <td><a title="etc" href="https://github.com/HengWang/mysql-audit/tree/master/etc" rel="nofollow">etc</a></td> 
 <td><a title="Add the object of database and table audit" href="https://github.com/HengWang/mysql-audit/commit/94af72e836f3abe7190f335c60dd314f34d24525" rel="nofollow">Add the object of database and table audit</a> </td> 
 <td>2 years ago</td> 
 </tr> 
 <tr> 
 <td><img width="16" height="16" alt="" src="https://assets-cdn.github.com/images/spinners/octocat-spinner-32.gif"></td> 
 <td><a title="file" href="https://github.com/HengWang/mysql-audit/tree/master/file" rel="nofollow">file</a></td> 
 <td><a title="Update the check_opbjects procedure" href="https://github.com/HengWang/mysql-audit/commit/2b99dbb25b0c2ae2252714c5d535caaa823621b0" rel="nofollow">Update the check_opbjects procedure</a> </td> 
 <td>2 years ago</td> 
 </tr> 
 <tr> 
 <td><img width="16" height="16" alt="" src="https://assets-cdn.github.com/images/spinners/octocat-spinner-32.gif"></td> 
 <td><a title="include" href="https://github.com/HengWang/mysql-audit/tree/master/include" rel="nofollow">include</a></td> 
 <td><a title="Update the check_opbjects procedure" href="https://github.com/HengWang/mysql-audit/commit/2b99dbb25b0c2ae2252714c5d535caaa823621b0" rel="nofollow">Update the check_opbjects procedure</a> </td> 
 <td>2 years ago</td> 
 </tr> 
 <tr> 
 <td><img width="16" height="16" alt="" src="https://assets-cdn.github.com/images/spinners/octocat-spinner-32.gif"></td> 
 <td><a title="script" href="https://github.com/HengWang/mysql-audit/tree/master/script" rel="nofollow">script</a></td> 
 <td><a title="Add the object of database and table audit" href="https://github.com/HengWang/mysql-audit/commit/94af72e836f3abe7190f335c60dd314f34d24525" rel="nofollow">Add the object of database and table audit</a> </td> 
 <td>2 years ago</td> 
 </tr> 
 <tr> 
 <td><img width="16" height="16" alt="" src="https://assets-cdn.github.com/images/spinners/octocat-spinner-32.gif"></td> 
 <td><a title="table" href="https://github.com/HengWang/mysql-audit/tree/master/table" rel="nofollow">table</a></td> 
 <td><a title="Update the check_opbjects procedure" href="https://github.com/HengWang/mysql-audit/commit/2b99dbb25b0c2ae2252714c5d535caaa823621b0" rel="nofollow">Update the check_opbjects procedure</a> </td> 
 <td>2 years ago</td> 
 </tr> 
 <tr> 
 <td><img width="16" height="16" alt="" src="https://assets-cdn.github.com/images/spinners/octocat-spinner-32.gif"></td> 
 <td><a title="test" href="https://github.com/HengWang/mysql-audit/tree/master/test" rel="nofollow">test</a></td> 
 <td><a title="Update the check_opbjects procedure" href="https://github.com/HengWang/mysql-audit/commit/2b99dbb25b0c2ae2252714c5d535caaa823621b0" rel="nofollow">Update the check_opbjects procedure</a> </td> 
 <td>2 years ago</td> 
 </tr> 
 <tr> 
 <td><img width="16" height="16" alt="" src="https://assets-cdn.github.com/images/spinners/octocat-spinner-32.gif"></td> 
 <td><a title="CMakeLists.txt" href="https://github.com/HengWang/mysql-audit/blob/master/CMakeLists.txt" rel="nofollow">CMakeLists.txt</a></td> 
 <td><a title="Version 2.2" href="https://github.com/HengWang/mysql-audit/commit/bcc5872667d59372191919e4b09b3a3b1e5dd128" rel="nofollow">Version 2.2</a> </td> 
 <td>2 years ago</td> 
 </tr> 
 <tr> 
 <td><img width="16" height="16" alt="" src="https://assets-cdn.github.com/images/spinners/octocat-spinner-32.gif"></td> 
 <td><a title="ChangeList" href="https://github.com/HengWang/mysql-audit/blob/master/ChangeList" rel="nofollow">ChangeList</a></td> 
 <td><a title="Update the check_opbjects procedure" href="https://github.com/HengWang/mysql-audit/commit/76ff1da5c6b4235fe380d0e08462d303463c7972" rel="nofollow">Update the check_opbjects procedure</a> </td> 
 <td>2 years ago</td> 
 </tr> 
 <tr> 
 <td><img width="16" height="16" alt="" src="https://assets-cdn.github.com/images/spinners/octocat-spinner-32.gif"></td> 
 <td><a title="README" href="https://github.com/HengWang/mysql-audit/blob/master/README" rel="nofollow">README</a></td> 
 <td><a title="Add the object of database and table audit" href="https://github.com/HengWang/mysql-audit/commit/94af72e836f3abe7190f335c60dd314f34d24525" rel="nofollow">Add the object of database and table audit</a> </td> 
 <td>2 years ago</td> 
 </tr> 
 <tr> 
 <td><img width="16" height="16" alt="" src="https://assets-cdn.github.com/images/spinners/octocat-spinner-32.gif"></td> 
 <td><a title="audit.cc" href="https://github.com/HengWang/mysql-audit/blob/master/audit.cc" rel="nofollow">audit.cc</a></td> 
 <td><a title="Add variables checking whether is NULL or not" href="https://github.com/HengWang/mysql-audit/commit/1b3449f953c46d09e947fe422650554def2762df" rel="nofollow">Add variables checking whether is NULL or not</a> </td> 
 <td>2 years ago</td> 
 </tr> 
 <tr> 
 <td><img width="16" height="16" alt="" src="https://assets-cdn.github.com/images/spinners/octocat-spinner-32.gif"></td> 
 <td><a title="audit_config.c" href="https://github.com/HengWang/mysql-audit/blob/master/audit_config.c" rel="nofollow">audit_config.c</a></td> 
 <td><a title="Add the object of database and table audit" href="https://github.com/HengWang/mysql-audit/commit/94af72e836f3abe7190f335c60dd314f34d24525" rel="nofollow">Add the object of database and table audit</a> </td> 
 <td>2 years ago</td> 
 </tr> 
 <tr> 
 <td><img width="16" height="16" alt="" src="https://assets-cdn.github.com/images/spinners/octocat-spinner-32.gif"></td> 
 <td><a title="audit_config.h" href="https://github.com/HengWang/mysql-audit/blob/master/audit_config.h" rel="nofollow">audit_config.h</a></td> 
 <td><a title="Version 2.2" href="https://github.com/HengWang/mysql-audit/commit/bcc5872667d59372191919e4b09b3a3b1e5dd128" rel="nofollow">Version 2.2</a> </td> 
 <td>2 years ago</td> 
 </tr> 
 <tr> 
 <td><img width="16" height="16" alt="" src="https://assets-cdn.github.com/images/spinners/octocat-spinner-32.gif"></td> 
 <td><a title="common.c" href="https://github.com/HengWang/mysql-audit/blob/master/common.c" rel="nofollow">common.c</a></td> 
 <td><a title="Version 2.2" href="https://github.com/HengWang/mysql-audit/commit/bcc5872667d59372191919e4b09b3a3b1e5dd128" rel="nofollow">Version 2.2</a> </td> 
 <td>2 years ago</td> 
 </tr> 
 </tbody> 
</table>

README

MySQL AUDIT 2.2
    
    This is a plugin of MySQL Server, the plugin based on MySQL Server audit plugin
    interface, aimed to audit the mysql database operations.  If you have the more 
    efficient method to audit the mysql database, thanks for your sharing with the 
    developer named heng wang. It's pleasure for you to contact me king_wangheng@163.com. 
    Welcome to join me to develop the more common and effective audit plugin in order
    to service more people. 
    
    
    Copyright (c) 2012, Heng.Wang. All rights reserved.
    
    You can get the source from github or sourceforge, the address is:
    git clone https://github.com/HengWang/mysql-audit.git mysql-audit
    or
    https://sourceforge.net/projects/mysql-audit/
    
    The audit plugin relies on MySQL Server 5.5 or Percona Server 5.5. When I develop 
    the audit plugin, based on the MySQL Server 5.5.20, and test on MySQL Server 5.5.20,
    Percona Server 5.5.20, MySQL Server 5.5.15, Percona Server 5.5.15. Because of the 
    audit interface changed from MySQL Server 5.5.16, then test on 5.5.15 is needed.
    
    1. Compile the audit plugin
    1.1 If you get the audit plugin source from sourceforge, decompress the tar package.
    example:  tar -xvzf mysql-audit-2.2.tar.gz
    1.2 Move the audit plugin source into the directory "plugin/" of MySQL Server. 
    example:  mv mysql-audit/ ${MYSQL_SOURCE_HOME}/plugin
    1.3 Compile and install the MySQL Server in usual.
    
    2. Change the granularity of the audit based on the application.
    The location of configure file : ${CMAKE_INSTALL_PREFIX}/lib/plugin/audit.cnf,
    default audit nothing. 
    
    3. Start the MySQL Server in usual.
    
    4. Install the audit plugin.
    Login the MySQL Server with mysql client, and execute the sql statement:
    mysql> install plugin audit soname 'audit.so';
    
    5. Uninstall the audit plugin.
    Login the MySQL Server with mysql client, and execute the sql statement:
    mysql> uninstall plugin audit;

**注：近期参加MySQL运维学习，老师推荐该文章作为学习和技术提高的扩展阅读，先记录到自己的博客中，随后慢慢消化、学习、提高。本文章与“字符集和权限安全”主题相关。**

[HengWang]: https://github.com/HengWang
[mysql-audit]: https://github.com/HengWang/mysql-audit
[octocat-spinner-32.gif]: https://assets-cdn.github.com/images/spinners/octocat-spinner-32.gif
[Issues 1_octocat-spinner-32.gif_]: https://github.com/HengWang/mysql-audit/issues
[Pull Requests 0_octocat-spinner-32.gif_]: https://github.com/HengWang/mysql-audit/pulls
[Pulse _octocat-spinner-32.gif_]: https://github.com/HengWang/mysql-audit/pulse
[Graphs _octocat-spinner-32.gif_]: https://github.com/HengWang/mysql-audit/graphs
[Network _octocat-spinner-32.gif_]: https://github.com/HengWang/mysql-audit/network
[HTTPS]: https://github.com/HengWang/mysql-audit#
[Link 1]: https://help.github.com/articles/which-remote-url-should-i-use
[Clone in Desktop]: http://windows.github.com/
[Download ZIP]: https://github.com/HengWang/mysql-audit/archive/master.zip
[10 commits]: https://github.com/HengWang/mysql-audit/commits/master
[2 branches]: https://github.com/HengWang/mysql-audit/branches
[0 releases]: https://github.com/HengWang/mysql-audit/releases
[1 contributor]: https://github.com/HengWang/mysql-audit/graphs/contributors
[C 52.2_]: https://github.com/HengWang/mysql-audit/search?l=c
[C_ 44.1_]: https://github.com/HengWang/mysql-audit/search?l=c%2B%2B
[Shell 3.7_]: https://github.com/HengWang/mysql-audit/search?l=shell
[master]: https://github.com/HengWang/mysql-audit/tree/master
[version-3.0]: https://github.com/HengWang/mysql-audit/tree/version-3.0
[Add variables checking whether is NULL or not]: https://github.com/HengWang/mysql-audit/commit/1b3449f953c46d09e947fe422650554def2762df
[Heng Wang]: /images/20220823/7453e83d4cfb4262a25754a417d441d6.png

HengWang/mysql-audit

发表评论取消回复

还没有评论，来说两句吧...

相关阅读