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

导入数据库时报错：
[mysqld]
6 j0 b+ Q/ b* w5 M- s
innodb_file_format = Barracuda
innodb_file_format_check = ON
innodb_file_format_max = Barracuda
: E( d/ B( [2 G& J7 E. r[mysql.server]
6 A* S) m/ M2 I' T+ j8 r! q+ y' Ginnodb_file_format = Barracuda
innodb_file_format_check = ON
innodb_file_format_max = Barracuda
# w, P* l. `* F9 A: k
% C: x3 T+ ]6 ]7 a3 e
在my.cnf文件中添加上面信息：
3 |4 I# {  l: x& D4 Q2 X. e' t  I
% o# R# p$ a) ~0 z4 N: ]8 j" ^( c4 wcollation-server = utf8mb4_general_ci
init-connect = 'SET NAMES utf8mb4'
character-set-server = utf8mb4
innodb_file_format = Barracuda
( T0 e+ t7 j* X% linnodb_file_format_check = ON
innodb_file_format_max = Barracuda
! ?" \1 ?5 M7 V7 ]: G0 j! g: finnodb_large_prefix = ON
[mysql.server]
innodb_file_format = Barracuda
. h$ t4 _5 A0 Z+ _' X" T. Zinnodb_file_format_check = ON
1 c3 K% C, s# e4 einnodb_file_format_max = Barracuda
7 O8 m0 \9 m, y$ z, Z. ^9 Cinnodb_large_prefix = ON
% d/ n6 D  t: _5 ldefault-character-set = utf8mb4
. T( ~! K+ a) D$ A3 q. zcharacter_set_server = utf8mb4
[client]
" M3 Q1 G2 z! H, ^8 K% }' A5 Mdefault-character-set = utf8mb4
5 ^6 U' t1 O3 c7 r  p# u; C[mysqld_safe]
default-character-set = utf8mb4
/ E  e5 Z8 _# c6 e; \
: [/ F% l  x# E' |! Z3 I# c