mysql> show variables like
'plugin_dir'
;
+---------------+---------------------------------+
3 | Variable_name | Value |
4 +---------------+---------------------------------+
5 | plugin_dir | /usr/local/mysql/lib/plugin/ |
6 +---------------+---------------------------------+
查看plugin目录下是否有ha_archive.so
1 ll /usr/local/mysql/lib/plugin/
2 -rwxrwxr-x 1 mysql mysql 229904 Aug 15 20:40 ha_archive.so
安装引擎
mysql> install plugin archive soname 'ha_archive.so';
如果碰到如下错误提示,打开my.cnf,删除skip-grant-tables这行,重启MySQL后重新安装即可~
mysql> ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement