MySQL中mariadb的my.cnf配置文件

admin

[mysqld]
bind-address=192.168.0.11   #本机IP地址
  g( j# a: |: |default-storage-engine=innodb
innodb_file_per_table=on
max_connections=4096
# ^9 ~/ B) x$ S" L0 I; Jcollation-server=utf8_general_ci
character-set-server=utf8
1 {3 o5 N4 E: W8 G


1 ~4 x4 M8 @: v+ U0 K
2 A3 Y' ^! @# J( |第二种添加字符集：
4 d: A4 x0 h. }4 f4 k' J+ I在my.cnf中添加这样的字段
[mysqld]
( A" L* p2 d8 ~3 |! ~# x# tinit_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_general_ci
0 y2 L$ b( q: z+ Y$ m[client]
default-character-set=utf8
socket=/var/lib/mysql/mysql.sock
" O$ Y! h8 k$ S8 f6 [; v1 M

systemctl restart mariadb.service
' m, a7 S& }2 q! J0 M3 r

admin

设置忽略大小写： 在[mysqld]中添加下列语句
  lower_case_table_names=1