Tag Archives: Mysql ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

[Solved] Mysql ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

 

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;