|
|
[mysqld]0 `4 \* E# \# F/ s
bind-address=192.168.0.11 #本机IP地址4 @6 Y" y e' d% p
default-storage-engine=innodb S9 z5 w r. X4 K
innodb_file_per_table=on( B; ~( M, T7 A! V
max_connections=4096
( D( _4 U1 D9 D9 {. ^0 h- i. H! Tcollation-server=utf8_general_ci Q, M/ @: k; H
character-set-server=utf8
. o8 t8 w- S) B9 H2 r: Z) I; g. l
! B; [" s' h$ B% i; u
$ H @( ?1 j5 y, t& m" i3 F1 A6 Z- u! `
$ L! e$ k2 A3 [: ^第二种添加字符集：
/ }" Y% p) {: a; ^ d8 }' Q2 U在my.cnf中添加这样的字段1 [7 C0 K/ }" A0 T# j7 X
[mysqld]8 a! P5 L1 X) T) m- R: a5 o# l
init_connect='SET collation_connection = utf8_general_ci' z& T* W1 L& ~% Y3 t( Z$ c
init_connect='SET NAMES utf8'0 ^+ N# ?" }' L( Z: u% v
character-set-server=utf8; K+ \% l* F9 x1 o) R; ], _
collation-server=utf8_general_ci
+ h+ d, U: ]" L0 h, |- u! k9 z[client]0 M4 C" ?* ^! q9 }
default-character-set=utf89 N* y2 ]1 w; U2 \4 F v* n: |7 m
socket=/var/lib/mysql/mysql.sock( L; b* z% q7 {
$ t9 @ w9 U6 m/ @" I& C
9 G9 k: e$ k# y1 x3 asystemctl restart mariadb.service
% t; V0 ~% m- @6 {% R' t |
|
发表于 2018-7-4 15:50:11