|
|
[mysqld]
: K9 w: v0 L; r5 B2 Jbind-address=192.168.0.11 #本机IP地址* _2 U. m$ ]7 Y
default-storage-engine=innodb9 {! m. m2 ?+ m6 M/ P5 J
innodb_file_per_table=on
8 G2 b1 f! N, u- ]max_connections=4096( M4 X( h3 J( V6 C
collation-server=utf8_general_ci+ X- H2 p3 Z( B4 a. E- a6 M
character-set-server=utf8, \& o& P( d& ?
% h! h; ^( u' i$ d; V7 I
0 W( F5 ?. |$ O" ]& b
& \ F: w5 G' G/ s) T* A" V2 Y
: P( m9 x) }) w/ c, s6 M, P& d第二种添加字符集：
% ~( Q% W$ J6 D/ k1 |在my.cnf中添加这样的字段
. Z+ J/ P: {! `5 L[mysqld], x; E1 f* C8 R4 t6 q7 w S! m: n
init_connect='SET collation_connection = utf8_general_ci'& _- v$ E! K5 J# B
init_connect='SET NAMES utf8'
" \* D0 O A* m3 D2 ?. ucharacter-set-server=utf8
/ f) G }, @$ G1 {! O6 Ecollation-server=utf8_general_ci
e0 N. ]( [/ w$ `[client]+ g6 y* Y) h2 {6 G0 ~7 x) v! [6 B% p
default-character-set=utf81 Q/ B! _! G" o% j- W
socket=/var/lib/mysql/mysql.sock6 [1 _5 c# z1 T+ M
/ g' {- N+ {& a2 G2 |" u" s9 ]. D5 |- z+ F9 s
systemctl restart mariadb.service
8 ~3 B( P+ R' c* w9 ^3 C |
|
发表于 2018-7-4 15:50:11