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
https://stackoverflow.com/a/43403017/69938
add to my.cnf
innodb_file_format=Barracuda innodb_file_per_table=1 innodb_large_prefix=1 binlog_format=ROW