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
You can install a plugin dynamically by executing theINSTALL SONAMEstatement.INSTALL SONAMEinstalls all plugins from the given plugin library. This could be required for some plugin libraries. For example, to install all plugins in theserver_auditplugin library (which is currently only theserver_aud...
| 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...
1)登录数据库,执行如下命令,查看插件位置 show variables like '%plugin%' ; 2)入到/usr/lib64/mysql/plugin/目录(该目录为步骤(1)的plugin_dir目录),查看是否有server_audit.so文件,如果没有的话,访问http://www.skysql.com/downloads/mariadb-audit-plugin-beta下载后传到/usr/lib64/mysql/plugin/目录。
/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 | +---+---+ | plugin_...
MariaDB [(none)]> SHOW VARIABLES LIKE 'plugin_dir'; #插件地址路径 +---+--- ---+ | Variable_name | Value | +---+--- + | plugin_dir | /usr/local/mysql/lib/plugin/ | +---+---+ 1 row in set (0.00 sec) 如果想永久加载,只需在配置...
plugin-dir=D:/develop/mariadb-10.4.7-winx64/lib/plugin 3、修改之后,发现还是不行,删库,重新建,删表,重新建,还是不行。 变化的是之前的?变成乱码了。 网上搜了一个遍,没有思路。因为我是通过powershell连接的,心想,装个navicat看看吧,到底啥原因。
编译成功后得到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...
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 ...
cnf --datadir=/data/mariadb --pid-file=/data/mariadb/hf-01.pid mysql 3242 3.6 6.2 1125520 62780 ? Sl 04:52 0:00 /usr/local/mariadb/bin/mysqld --defaults-file=/usr/local/mariadb/my.cnf --basedir=/usr/local/mariadb --datadir=/data/mariadb --plugin-dir=/usr/local/mariadb/...