初始化sql报错:Index column size too large. The maximum column size is 767 bytes
错误原因:数据库索引过长超过限制,数据库引擎为INNODB 引擎,编码UTF-8,主键字符串默认最大767。
解决办法:
1、修改数据库配置:
vi /etc/my.cnf
2、添加如下2个配置:
innodb_large_prefix=on
innodb_file_format=BARRACUDA
3、重启数据库:
systemctl restart mysqld
4、验证是否成功:
show variables like ‘innodb_large_prefix’;
show variables like ‘innodb_file_format’;
5、在sql语句后添加:
ROW_FORMAT=DYNAMIC;
执行成功!