Mysql5.6 is closed by default and 5.7 is open by default
show variables like '%innodb_large_prefix%';
set global innodb_large_prefix=on;
show variables like '%innodb_file_format%';
#output:
innodb_file_format Antelope
innodb_file_format_check ON
innodb_file_format_max Antelope
set global innodb_file_format=Barracuda;