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, `. L& D0 K$ f+ U& D# |导入数据库时报错：
[mysqld]
' @5 L6 Y% z  {' d* y  I9 I
innodb_file_format = Barracuda
innodb_file_format_check = ON
innodb_file_format_max = Barracuda
5 W# J% O' W0 @9 m3 s3 e[mysql.server]
innodb_file_format = Barracuda
# f' V8 a7 A, g5 Qinnodb_file_format_check = ON
; T6 C% |# a8 s/ q8 zinnodb_file_format_max = Barracuda

, ]) g  n1 J2 N8 F# L$ ~5 E
在my.cnf文件中添加上面信息：
% |: m% W$ ~6 \/ @+ e
3 x# `( R4 R& f) a( Scollation-server = utf8mb4_general_ci
! Q- N: I5 a* m/ y7 w6 Dinit-connect = 'SET NAMES utf8mb4'
. T( k4 m) h6 a& X7 Ycharacter-set-server = utf8mb4
innodb_file_format = Barracuda
innodb_file_format_check = ON
innodb_file_format_max = Barracuda
2 u; n3 S: H( s$ kinnodb_large_prefix = ON
[mysql.server]
7 X$ q0 h" F$ @1 H  Linnodb_file_format = Barracuda
9 G2 E& ~. z  B+ ]% j7 E6 a$ W8 ]innodb_file_format_check = ON
% E/ @1 V4 ^# ?( q7 V: D3 e( u/ h: V6 zinnodb_file_format_max = Barracuda
- W8 K+ h' X9 H5 minnodb_large_prefix = ON
default-character-set = utf8mb4
character_set_server = utf8mb4
1 E4 y$ ^6 ~: h. ~. l) u& H' P[client]
default-character-set = utf8mb4
8 c% Q5 `- _) ]/ d$ ][mysqld_safe]
* e; T- F& U" r5 V' wdefault-character-set = utf8mb4