我是mysql新手,正在尝试在mysql社区8.0.11上安装keyring。
我使用的是windows,我用
[mysqld]
early-plugin-load=keyring_file.dll
然后我跑了
mysql> install plugin keyring_file soname 'keyring_file.dll';
我得到一个警告
+---------+------+------------------------------------------------------------ --------------------------------+
| Level | Code | Message |
+---------+------+--------------------------------------------------------------------------------------------+
| Warning | 29 | File 'C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin' not found (OS errno 13 - Permission denied) |
+---------+------+--------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
我检查它是否激活
mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS
-> FROM INFORMATION_SCHEMA.PLUGINS
-> WHERE PLUGIN_NAME LIKE 'keyring%';
那个插件是活动的。
但是当我试图用
mysql> ALTER TABLE example ENCRYPTION='Y';
ERROR 3185 (HY000): Can't find master key from keyring, please check keyring
plugin is loaded.
我不明白我错过了什么。
plugin目录是正确的(c:\program files\mysql\mysql server 8.0\lib\plugin)
和keyring文件数据是一样的!
暂无答案!
目前还没有任何答案,快来回答吧!