ERROR 1071 (42000) at line 162: Specified key was too long; max key length is 76

admin

ERROR 1071 (42000) at line 162: Specified key was too long; max key length is 767 bytes

导入数据库时报错：
- ]* y* b1 e: w7 K[mysqld]

innodb_file_format = Barracuda
innodb_file_format_check = ON
innodb_file_format_max = Barracuda
. J9 Y+ ~/ U3 v5 @[mysql.server]
innodb_file_format = Barracuda
3 u$ _% Z0 e+ h, _innodb_file_format_check = ON
0 N' k" |/ G4 g1 F8 u0 `" b( m+ ginnodb_file_format_max = Barracuda

' C- f+ |" y' g/ o; S+ W
: W( D+ t& D- ?1 a2 n3 n7 R: c在my.cnf文件中添加上面信息：
0 D, t. j% c) j
' R& y' s3 d( F: u6 Ecollation-server = utf8mb4_general_ci
; J$ b# }* t8 K; Jinit-connect = 'SET NAMES utf8mb4'
. {. r" C  @- wcharacter-set-server = utf8mb4
innodb_file_format = Barracuda
6 a+ L6 W& F0 ?# u" ~innodb_file_format_check = ON
innodb_file_format_max = Barracuda
innodb_large_prefix = ON
8 S% S6 i" b" ?! w/ [[mysql.server]
) A/ z2 x% \$ K5 tinnodb_file_format = Barracuda
- m; k$ a: X: `) e3 H7 p+ Einnodb_file_format_check = ON
. q' c5 M. u' M# f8 `innodb_file_format_max = Barracuda
5 E9 x, W9 n% m2 U3 B" uinnodb_large_prefix = ON
( L9 g$ y. `% m! T- R& wdefault-character-set = utf8mb4
character_set_server = utf8mb4
0 A; v' r" @9 d" \( K6 W3 s[client]
default-character-set = utf8mb4
) i' o1 k" }  j+ Z8 s# |[mysqld_safe]
default-character-set = utf8mb4
0 z7 ?% l& Z2 O1 X. X: |
( \0 Q) i- r  n# a