Error Code: 1071 - Specified key was too long; max key length is 767 bytes

show variables like '%innodb_large_prefix%';
set global innodb_large_prefix=on;
show variables like '%innodb_file_format%';

保证innodb_file_format和innodb_file_format_max这两个都是Barracuda
set global innodb_file_format=Barracuda;

使用这个命令查一下row_format是否为Dynamic
show table status from MyDB where name='TEST';

是的话直接修改表中错误引起这个错误的字段,不是的话执行下面的命令

ALTER TABLE TEST ROW_FORMAT=DYNAMIC;