Monthly Archives: June 2017

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

This video shows how to correct the error:

 

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

 

The commands that you will need to run to correct the error are:

 

SET GLOBAL innodb_file_format=Barracuda;
SET GLOBAL innodb_file_per_table=on;
SET GLOBAL innodb_large_prefix=on;