Re: MySQL keyring problem

[Georgi Kodinov]

Can you please check your mysql error log file (and/or Windows event viewer) for any errors ?
Based on the error you're getting I believe you don't have the correct path for the server to find plugins set up.
Or there's something wrong with the user account you're running the server with as it can't access C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin

You can also check the plugin state by doing "SHOW PLUGINS" and looking for the keyring_file plugin.

Otherwise both --[early-]plugin-load and INSTALL PLUGIN do exactly the same thing: they install a plugin. So no need to do both.

The difference between the two is that early-plugin-load initializes the plugin *before* the innodb storage engine is initialized. While INSTALL PLUGIN does install it after innoDB.

And obviously InnoDB needs to read the keys from the keyring plugin. Thus I suggest you stick with early-plugin-load.

Georgi "Joro" Kodinov
MySQL SrvGen team lead
Plovdiv, Bulgaria