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

- p( {- p: d( n6 ?7 T( t. X# ]导入数据库时报错：
[mysqld]

) Z5 h9 A' E* A' W6 V3 F# ainnodb_file_format = Barracuda
innodb_file_format_check = ON
4 K* z' a0 n5 x0 d# l% {innodb_file_format_max = Barracuda
" Q+ `1 u) P8 S1 ]$ [$ y4 U! V[mysql.server]
innodb_file_format = Barracuda
innodb_file_format_check = ON
innodb_file_format_max = Barracuda


在my.cnf文件中添加上面信息：

( O4 n# \6 G9 a. w2 W4 u: f( ycollation-server = utf8mb4_general_ci
( ^" Y" U) y- B; i1 r- @! Cinit-connect = 'SET NAMES utf8mb4'
4 U6 F1 ^$ i# ], M8 k- l: a5 dcharacter-set-server = utf8mb4
innodb_file_format = Barracuda
! a1 O' j) |8 Kinnodb_file_format_check = ON
innodb_file_format_max = Barracuda
; l* `# u3 `; w- m! \innodb_large_prefix = ON
[mysql.server]
+ P0 \7 W) ^1 e4 @7 @5 V1 Ninnodb_file_format = Barracuda
( w' K* t# O* ^, L$ _' [innodb_file_format_check = ON
7 d- V5 b  ~2 Z3 M* \innodb_file_format_max = Barracuda
& K- Z- C4 c" X& g, Dinnodb_large_prefix = ON
default-character-set = utf8mb4
2 A/ c: y& j5 |& ~: l+ d7 z5 E4 F5 ycharacter_set_server = utf8mb4
1 M3 e  ]$ u* W[client]
default-character-set = utf8mb4
[mysqld_safe]
* O4 n) o) M; t. r3 ndefault-character-set = utf8mb4