<code>
SET GLOBAL innodb_file_format=Barracuda;
SET GLOBAL innodb_file_per_table=ON;
SET GLOBAL innodb_large_prefix=1;
logout & login (to get the global values);
ALTER TABLE tbl ROW_FORMAT=DYNAMIC;  -- or COMPRESSED
</code>
https://stackoverflow.com/a/43403017/69938


add to my.cnf

<code>
innodb_file_format=Barracuda
innodb_file_per_table=1
innodb_large_prefix=1
binlog_format=ROW
</code>