MySQL中mariadb的my.cnf配置文件

admin

[mysqld]
  o/ i" w+ C( r+ u- e% Z. wbind-address=192.168.0.11   #本机IP地址
' h9 [$ q8 ^% L5 W  K- j0 B1 ^" @; ldefault-storage-engine=innodb
innodb_file_per_table=on
) L' v% Q8 J( {) j+ `9 ^  V! ?max_connections=4096
% n9 J" j0 O0 `2 R3 wcollation-server=utf8_general_ci
) t9 Q7 M$ ~' l0 {1 K* z$ Q4 Scharacter-set-server=utf8


+ o" |0 Q2 C8 d5 @
- X% C$ j9 _* K! K, C
第二种添加字符集：
6 X/ G) q- g4 G* N, R' g& L在my.cnf中添加这样的字段
[mysqld]
- T% G& i' w% R9 Yinit_connect='SET collation_connection = utf8_general_ci'
% f+ i& m/ H! |, ]! l0 n' U9 R, Pinit_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_general_ci
[client]
default-character-set=utf8
0 W4 |4 z# i6 I! w# v" j0 \8 b$ c/ Nsocket=/var/lib/mysql/mysql.sock

* `7 }' P1 R9 j, k+ H, ~
' V* t& V" C+ Q+ nsystemctl restart mariadb.service

admin

设置忽略大小写： 在[mysqld]中添加下列语句
$ `, h! s; l3 P( d% U7 Z- \  lower_case_table_names=1