安装gogs 出现 Specified key was too long; max key length is 1000 byte

安装gogs 出现 Specified key was too long; max key length is 1000 byte

是因为 低于mysql 5.7的版本 用于低于mysql 5.6 可以使用

导入sql

SET GLOBAL innodb_file_per_table = ON,
innodb_file_format = Barracuda,
innodb_large_prefix = ON;
DROP DATABASE IF EXISTS gogs;
CREATE DATABASE IF NOT EXISTS gogs CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;