|
|
[mysqld]
* Z- {; t+ B# `6 O! Lbind-address=192.168.0.11 #本机IP地址 j; a$ u2 H, {+ L! T
default-storage-engine=innodb+ Z4 J; ?& z" S/ M" l3 m
innodb_file_per_table=on
0 X! A) ^0 `6 e( imax_connections=4096
: `( a+ s5 D6 Ycollation-server=utf8_general_ci0 G0 M6 t; {8 y1 s
character-set-server=utf80 R% s. U# E) ^ a0 _+ e, M Y
$ o6 Z0 L/ k7 n' b5 v' |. s7 H. |7 f7 _* _& i" J! R2 e' K8 k; u
) t) g2 N* P0 x Z |5 Z( C0 i
* |; V) q0 g: @6 H [
第二种添加字符集：
2 u6 v- e5 V' B" y* N7 E; }& B在my.cnf中添加这样的字段/ O: l' ^) e& q( K* {! W: h1 F
[mysqld]+ A# H i' v c% Z6 N) [
init_connect='SET collation_connection = utf8_general_ci': E& Y3 T( i) b/ e- ?; k2 m, _& j; \
init_connect='SET NAMES utf8') Z+ o% Z* }% q) |* y4 {
character-set-server=utf8
( V$ v5 b. i9 Qcollation-server=utf8_general_ci
: c. F/ E0 J3 p0 q. `$ b[client]0 {0 A; t+ o/ ~
default-character-set=utf8; E8 S# j8 K L6 A: R8 V: z
socket=/var/lib/mysql/mysql.sock, D+ }6 Y3 x: @- w- f8 M2 R/ c# {
% M$ D& }4 F7 N, |9 _( y7 U/ U# _$ x7 @. T- H, K: J( @
systemctl restart mariadb.service
0 @/ @- j$ s- ^4 c |
|
发表于 2018-7-4 15:50:11