报错如下:
mysql> CREATE FUNCTION lib_mysqludf_sys_info RETURNS string SONAME 'lib_mysqludf_sys.so';
ERROR 1126 (HY000): Can't open shared library 'lib_mysqludf_sys.so' (errno: 22 lib_mysqludf_sys.so: cannot open shared object file: No such file or directory)
mysql>
redhat 4的服务器,selinux关闭
mysql安装路径为:/usr/local/mysql5.0.45
lib_mysqludf_sys.so放在如下位置:
[root@localhost mysql5.0.45]# locate lib_mysqludf_sys.so
/usr/local/mysql5.0.45/lib/mysql/plugin/lib_mysqludf_sys.so
/usr/local/mysql5.0.45/lib/mysql/lib_mysqludf_sys.so
/usr/lib/mysql/plugin/lib_mysqludf_sys.so
/usr/lib/mysql/lib_mysqludf_sys.so
/usr/lib/lib_mysqludf_sys.so
/lib/lib_mysqludf_sys.so
在高版本的mysql上可以创建成功,不知道是不是哪里设置有问题,求解!
感谢