innodb_large_prefix设置步骤

在终端输入mysql -uroot -p，之后输入密码即可运行下列：

mysql> set global innodb_file_format = BARRACUDA;

Query OK, 0 rows affected (0.00 sec)

mysql> set global innodb_large_prefix = ON;

Query OK, 0 rows affected (0.00 sec)

mysql可导入navicat生成的sql.