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
[mysqld]
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
[mysqld]
#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
keyring.
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
