plugin_dir Directory for plugins See also:System Variables for MariaDB Enterprise Server 11.4,in 10.6 ES,in 10.5 ES,in 10.4 ES,in 10.3 ES,in 10.2 ES,in 10.6 CS,in 10.5 CS,in 10.4 CS,in 10.3 CS, andin 10.2 CS DE
not in a subdirectory. By default,plugin_diris plugin directory under the directory named by thepkglibdirconfiguration variable, but it can be changed by setting the value ofplugin_dirat server startup.
| plugin_dir | /usr/local/mysql/lib/plugin/ | +---+---+ 1 row in set (0.01 sec) MariaDB [test]> install plugin server_audit SONAME 'server_audit.so'; Query OK, 0 rows affected (0.05 sec) MariaDB [test]> show variables like 'server%'; +---+---+ | Variable_name | Value...
解压MariaDB获取server_audit.so可用于mysql /mariadb-10.5.3-linux-x86_64.tar.gz/mariadb-10.5.3-linux-x86_64/lib/plugin 目录下server_audit.so拷贝到/usr/lib64/mysql/plugin 查看插件安装目录 mysql> show global variables like 'plugin_dir'; +---+---+ | Variable_name | Value | +---+--...
service ├─4278 /bin/sh /usr/bin/mysqld_safe --basedir=/usr └─4442 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --... Mar 15 19:23:46 iZwz9edz6cpxxf0o19aqisZ mariadb-prepare-db-dir[4192]: MySQL manual for more ...
2)入到/usr/lib64/mysql/plugin/目录(该目录为步骤(1)的plugin_dir目录),查看是否有server_audit.so文件,如果没有的话,访问http://www.skysql.com/downloads/mariadb-audit-plugin-beta下载后传到/usr/lib64/mysql/plugin/目录。 3)安装插件,有两种方式: ...
datadir=D:/develop/mariadb-10.4.7-winx64/data [mysql] default-character-set = utf8 [mysql.server] default-character-set = utf8 [client] default-character-set = utf8 plugin-dir=D:/develop/mariadb-10.4.7-winx64/lib/plugin 3、修改之后,发现还是不行,删库,重新建,删表,重新建,还是不行。
MariaDB [(none)]> SHOW VARIABLES LIKE 'plugin_dir'; #插件地址路径 +---+--- ---+ | Variable_name | Value | +---+--- + | plugin_dir | /usr/local/mysql/lib/plugin/ | +---+---+ 1 row in set (0.00 sec) 如果想永久加载,只需在配置...
datadir = /data/mysql/columnstore/data tmpdir = /data/mysql/columnstore/tmp log-error = /data/mysql/columnstore/log/error.log socket = /tmp/mysql_mariadb.sock skip-slave-start skip-external-locking skip-name-resolve sql_mode = ''plugin-load-add = ha_columnstore.so default-storage-engine =...
编译成功后得到my_auth_plugin.so。 2、复制 编译得到.so文件后需要将.so文件复制到MariaDB的插件目录中。进入MariaDB,用如下语句查询插件目录: MariaDB [(none)]> SHOW VARIABLES LIKE 'plugin_dir'; +---+---+ | Variable_name | Value | +---+---+ | plugin_dir | /usr/local/mysql/lib/plugi...