MySQL Forums
Forum List  »  Security

Re: MySQL keyring problem
Posted by: Georgi Kodinov
Date: June 29, 2018 02:14AM

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

Options: ReplyQuote

Written By
June 28, 2018 06:27AM
Re: MySQL keyring problem
June 29, 2018 02:14AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.