Troubleshooting

Unable to encrypt the tables and there is not any action under ESKM.

Also, we have checked the error logs of mysql and found below logs.

[ERROR] [MY-012657] [InnoDB] Encryption can't find master key, please check the keyring is loaded.

[ERROR] [MY-012226] [InnoDB] Encryption information in datafile:

.\mysql_tde_test\test_encryption.ibd can't be decrypted, please confirm that keyring is loaded.

• We must take care that during the server startup process, keyring_okv must be loaded using the--early-plugin-load option.

• Also, set the keyring_okv_conf_dir system variable to tell keyring_okv where to find its configuration directory. Edit the /C:\Program Data\MySQL\MySQL Server 8.0/my.ini file and add the plugin into the mysqld section.

• Restarted the MySQL services. Hence issue got resolved.