|
|
[mysqld]
) u" \9 z4 ]: ~2 G; X& D. a) }$ U, lbind-address=192.168.0.11 #本机IP地址
& g0 {. H4 N8 Udefault-storage-engine=innodb
7 E; R) W& D7 X' F ` M: E3 d- kinnodb_file_per_table=on5 v# T7 d# e0 ]$ S
max_connections=4096
( w0 x* {6 R2 I) x; D. p/ B1 R3 zcollation-server=utf8_general_ci
/ |9 T0 A2 a1 c/ L* ?1 |: d8 x- D; Echaracter-set-server=utf8
+ q5 k$ z* ^: X3 s- j, \( p/ b4 a+ `. B' `; w
' ]% V& D; n9 t/ c3 @$ z
* J& d% b p; q6 \5 p: M6 l5 t# N/ H( e. P' \+ Y" z
第二种添加字符集：$ F1 @, y0 T4 y; a3 V4 O/ _
在my.cnf中添加这样的字段
7 f: Y6 e9 R E[mysqld]
, b0 Q/ P# `6 B1 @- n4 S) W6 T; k- y+ Yinit_connect='SET collation_connection = utf8_general_ci'5 y1 I( a: i; J1 o. e
init_connect='SET NAMES utf8'' g) Z- M8 R6 r5 o" i X, o2 D( @2 i
character-set-server=utf8
: w! m2 _! r9 `/ l. i6 Ucollation-server=utf8_general_ci
4 Z6 v1 m L8 @+ `( W: L$ @[client]" |' W. c) \ P% R( g C
default-character-set=utf8. Q$ ?- x, A6 J7 Y4 t3 B
socket=/var/lib/mysql/mysql.sock
& E6 o9 I* Q S# K2 E5 v* B
# A T) A# B" w3 D$ [
9 t8 {) C* [) W4 [) X+ G+ isystemctl restart mariadb.service+ o1 r& v" P( m; C9 W! T
|
|
发表于 2018-7-4 15:50:11