sandip2308 avatar image
sandip2308 asked

issue regarding mysql keyring plugin.

Dear Team,

We have set up mysql enterprise edition 8.0 and trying to load load the keyring pulgin on windows server 2019.

The plugin loaded successfully


early-plugin-load = keyring_file.dll

keyring_file_data=C:/Program Files/MySQL/MySQL Server 8.0/keyring

And we have created the one database and created table under same database.

after Test that encryption KMIP is working

mysql> INSERT INTO test_encryption VALUES (1, 'cleandro');

Query OK, 1 row affected (0.00 sec)

mysql> select * from test_encryption;


| id | name |


| 1 | cleandro |


1 row in set (0.00 sec)

After that Edit the MySQL configuration file and disable the keyring_okv plugin, so i have committed above entries as below


#early-plugin-load = keyring_file.dll

#keyring_file_data=C:/Program Files/MySQL/MySQL Server 8.0/keyring

and restated the MySQL service. so after that expected output is we are getting error like

The table is not accessible because MySQL cannot get to the master key from the


But unfortunately we are not getting error and still above lines are committed.

mysql> use MySQL_TDE_Test;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select * from test_encryption;

ERROR 3185 (HY000): Can't find master key from keyring, please check in the server log if a keyring is loaded and

initialized successfully.

The output is expected as above and my.ini is committed.

I would like to request you please and suggest the steps to resolved this issue.

Thank you

Sandip Patil

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers


Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.