Specified key was too long; max key length is 767 bytes

set global innodb_large_prefix=on;
set global innodb_file_format=Barracuda;
set global innodb_file_format_max=Barracuda;

row_format 设置为dynamic 或compressed

已存在表:
ALTER TABLE TEST ROW_FORMAT=DYNAMIC;
新表:
create table QRTZ_PAUSED_TRIGGER_GRPS (
sched_name varchar(120) not null,
trigger_group varchar(200) not null,
primary key (sched_name,trigger_group)
) engine=innodb ROW_FORMAT=DYNAMIC;

原文地址:https://www.cnblogs.com/lianshan/p/11928986.html