I configured my MySQL 5.7.22 instance with
early-plugin-load = keyring_file.dll
in my.ini, restarted the service (on Windows Server 2016 Standard) then I created a table:
CREATE TABLE t1 (c1 INT) ENCRYPTION='Y';
Table was created correctly and it looks like the data is really encrypted (by looking into MySQL data folder). But when I try to ALTER the table (in Workbench) I see this:
Why do I get this "Error parsing DDL"?
Other statements like INSERT or SELECT works okay on this encrypted table.
Also ALTER on a non-encrypted table works normally.
I updated MySQL workbench and it works fine now :-)