MySQL Forums
Forum List  »  Security

MySQL keyring problem
Posted by: marco gianfelice
Date: June 28, 2018 06:27AM

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!

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL keyring problem
6631
June 28, 2018 06:27AM
1783
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.