Search code examples
mysqlencryptionalter

Error "Error parsing DDL" when trying to ALTER TABLE with ENCRYPTION = 'Y' (keyring plugin) in MySQL 5.7.22


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:

enter image description here

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.


Solution

  • I updated MySQL workbench and it works fine now :-)