centos7.3+ mysql5.6 + mysqludf安装

最新推荐文章于 2025-08-15 10:57:29 发布

xiaoxiao树

最新推荐文章于 2025-08-15 10:57:29 发布

阅读量1.8k

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.youkuaiyun.com/u010719917/article/details/78129755

mysql 专栏收录该内容

77 篇文章

订阅专栏

本文详细介绍了在CentOS7.3环境下安装MySQL5.6及mysqludf的过程。包括下载所需软件包、解决编译过程中遇到的问题、配置lib_mysqludf_sys.so等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

centos7.3+ mysql5.6 + mysqludf安装

相关连接：
http://blog.youkuaiyun.com/jssg_tzw/article/details/73235232
https://github.com/mysqludf
1.下载lib_mysqludf_sys
https://github.com/mysqludf/lib_mysqludf_sys
下载mysql-libs,mysql-connector,MySQL-devel
mysql-libs-5.1.73-5.el6_6.x86_64
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
MySQL-devel-5.6.37-1.el7.x86_64
一般只需要MySQL-devel就行
3.编译mysqludf
a. 解压：unzip lib_mysqludf_sys-master.zip

root@tmsjzt1:/opt/lib_mysqludf_sys-master# ll -rwxr-xr-x 1 root root 1544 Sep 7 10:47 install.sh
-rw-r--r-- 1 root root 7715 Sep 7 10:47 lib_mysqludf_sys.c
-rw-r--r-- 1 root root 9934 Sep 7 10:47 lib_mysqludf_sys.html
-rwxr-xr-x 1 mysql mysql 10714 Sep  7 10:48 lib_mysqludf_sys.so
-rw-r--r-- 1 root root 1647 Sep  7 10:47 lib_mysqludf_sys.sql
-rw-r--r-- 1 root root 122 Sep  7 10:47 Makefile

b. 运行：

gcc -DMYSQL_DYNAMIC_PLUGIN -fPIC -Wall -I /usr/include/mysql -I. -shared lib_mysqludf_sys.c -o lib_mysqludf_sys.so
报如下错误：
lib_mysqludf_sys.c:40:23: fatal error: my_global.h: No such file or directory  #include <my_global.h>

解决方法：

安装 MySQL-devel-5.6.37-1.el7.x86_64.rpm   就可以
运行  gcc -DMYSQL_DYNAMIC_PLUGIN -fPIC -Wall -I /usr/include/mysql -I. -shared lib_mysqludf_sys.c -o lib_mysqludf_sys.so

没有报错。

注意：
运行install.sh 会报如下错误，其实这个脚本不需要运行

Compiling the MySQL UDF
   gcc -Wall -I/usr/include/mysql -I. -shared lib_mysqludf_sys.c -o /usr/lib/lib_mysqludf_sys.so
   lib_mysqludf_sys.c:40:23: fatal error: my_global.h: No such file or directory
    #include <my_global.h>
                          ^
   compilation terminated.
   make: *** [install] Error 1
   ERROR: You need libmysqlclient development software installed
   to be able to compile this UDF, on Debian/Ubuntu just run:
   apt-get install libmysqlclient15-dev

尝试很多方法都没法通过。其实根本就不需要运行install.sh 。可能是bugs原因，只需要运行

  gcc -DMYSQL_DYNAMIC_PLUGIN -fPIC -Wall -I /usr/include/mysql -I. -shared lib_mysqludf_sys.c -o lib_mysqludf_sys.so

就可以了。

配置
a.将生成的lib_mysqludf_sys.so 复制到plugin_dir ,并授mysql权限

root@tmsjzt1:/opt/lib_mysqludf_sys-master# ll
-rwxr-xr-x 1 root  root   1544 Sep  7 10:47 install.sh
-rw-r--r-- 1 root  root   7715 Sep  7 10:47 lib_mysqludf_sys.c
-rw-r--r-- 1 root  root   9934 Sep  7 10:47 lib_mysqludf_sys.html
-rwxr-xr-x 1 mysql mysql 10714 Sep  7 10:49 lib_mysqludf_sys.so
-rw-r--r-- 1 root  root   1647 Sep  7 10:47 lib_mysqludf_sys.sql
-rw-r--r-- 1 root  root    122 Sep  7 10:47 Makefile

root@tmsjzt1:/opt/lib_mysqludf_sys-master# chown mysql.mysql lib_mysqludf_sys.so
root@tmsjzt1:/opt/lib_mysqludf_sys-master# cp -p lib_mysqludf_sys.so  /data/mysql/lib/plugin/
root@tmsjzt1:/opt/lib_mysqludf_sys-master# ll /data/mysql/lib/plugin/lib_mysqludf_sys.so
-rwxr-xr-x 1 mysql mysql 10714 Sep  7 10:48 /data/mysql/lib/plugin/lib_mysqludf_sys.so

b.运行lib_mysqludf_sys.sql文件

root@tmsjzt1:/opt/lib_mysqludf_sys-master# mysql -uroot -proot1234
   Warning: Using a password on the command line interface can be insecure.
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 642952
   Server version: 5.6.34-log Source distribution
   Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
   Oracle is a registered trademark of Oracle Corporation and/or its
   affiliates. Other names may be trademarks of their respective
   owners.
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   (root@localhost:mysql.sock)[(none)]source /opt/lib_mysqludf_sys-master/lib_mysqludf_sys.sql
   Query OK, 0 rows affected, 1 warning (0.02 sec)
   Query OK, 0 rows affected, 1 warning (0.00 sec)
   Query OK, 0 rows affected, 1 warning (0.00 sec)
   Query OK, 0 rows affected, 1 warning (0.00 sec)
   Query OK, 0 rows affected, 1 warning (0.00 sec)
   Query OK, 0 rows affected (0.02 sec)
   Query OK, 0 rows affected (0.00 sec)
   Query OK, 0 rows affected (0.00 sec)
   Query OK, 0 rows affected (0.00 sec)
   Query OK, 0 rows affected (0.00 sec)

5.设置trigger 调用系统脚本

CREATE DEFINER=`fmn`@`%` TRIGGER `fmn`.`test_BEFORE_UPDATE` BEFORE UPDATE ON `test` FOR EACH ROW
BEGIN
      DECLARE ret INT;
       Select sys_exec(concat('echo ',new.a,' ',new.b,' >> /tmp/xx.log'))  INTO ret;
END

对test做操作：

use fmn ;
select * from test ;
insert into test select 1,2 ;
update test set a = 10  limit 2 ;

查看系统文件记录：

root@fmnser:/tmp# cat /tmp/xx.log
  10 2
  10 2