Unable to encrypt table using keyring plugin

[sandip patil]

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.