亲测有效：解决mysql 1071 和1709报错方案

解决方案：

打开mysql后台，输入对应的密码进入后台，查看对应的参数是否开启

第一个参数innodb_large_prefix**

mysql> show variables like '%innodb_large_prefix%';
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| innodb_large_prefix | OFF   |
+---------------------+-------+
1 row in set (0.00 sec)

mysql> set global innodb_large_prefix=on;
Query OK, 0 rows affected (0.00 sec)

• 开启第一个参数之后显示的报错内容是(1709, ‘Index column size too large. Themaximum column size is 767 bytes.’)继续往下设置参数

第二个参数innodb_file_format

mysql> show variables like '%innodb_file_format%';
+--------------------------+----------+
| Variable_name            | Value    |
+--------------------------+----------+
| innodb_file_format       | Antel