MySQL 建表报错 Specified key was too long； max key length is 1000 bytes

<p><span style="color: rgb(77, 77, 77); font-family: -apple-system, &quot;SF UI Text&quot;, Arial, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif, SimHei, SimSun; font-size: 16px; background-color: rgb(255, 255, 255);">在MySQL启动配置文件my.ini中添加或修改：</span></p><pre class="brush:bash;toolbar:false">default-storage-engine=INNODB<br/></pre><p>没有修改权限的情况下可以指定创建表为InnoDB<span style="color: rgb(77, 77, 77); font-family: -apple-system, &quot;SF UI Text&quot;, Arial, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;WenQuanYi Micro Hei&quot;, sans-serif, SimHei, SimSun; font-size: 16px; background-color: rgb(255, 255, 255);"></span><br/></p><p>ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci</p>