MySQL keyring problem
Hello!
I'm new with MySQL and i'm trying to install keyring on MySQL Community 8.0.11.
i'm using Windows and i edited my.ini file with
[mysqld]
early-plugin-load=keyring_file.dll
then i ran
mysql> install plugin keyring_file soname 'keyring_file.dll';
and i get a warning
+---------+------+--------------------------------------------------------------------------------------------+
| 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)
i check if it was active and
mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS
-> FROM INFORMATION_SCHEMA.PLUGINS
-> WHERE PLUGIN_NAME LIKE 'keyring%';
that plugin was active.
But when i try to modify my table with
mysql> ALTER TABLE example ENCRYPTION='Y';
ERROR 3185 (HY000): Can't find master key from keyring, please check keyring
plugin is loaded.
I don't get what i am missing.
plugin_dir is the correct one
(C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin)
and keyring_file_data is the same!
Subject
Views
Written By
Posted
MySQL keyring problem
8410
June 28, 2018 06:27AM
2289
June 29, 2018 02:14AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.