How To Set Mariadb Character To utf8 On CentOS7

How To Set Mariadb Character On CentOS7

1.更改之前mariadb字符集是

[root@ZABBIX ~]# mysql -uroot -p
Enter password: 

MariaDB [(none)]> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

2.修改 my.cnf文件，[mysqld]下增加 character-set-server=utf8

[root@ZABBIX ~]# vim /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
character-set-server=utf8

#Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0
log-bin=mysql-bin

#Settings user and group are ignored when systemd is used.
#If you need to run mysqld under a different user or group,
#customize your systemd unit file for mariadb according to the
#instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
include all files from the config directory
#
!includedir /etc/my.cnf.d
~
~
~
"/etc/my.cnf" 21L, 614C                                       1,1           All

3.修改 client.cnf文件，[client]和[client-mariadb]下增加 default-character-set=utf8

[root@ZABBIX ~]# vim /etc/my.cnf.d/client.cnf

#These two groups are read by the client library

#Use it for options that affect all clients, but not the server


[client]

default-character-set=utf8

#This group is not read by mysql client library,

#If you use the same .cnf file for MySQL and MariaDB,

#use it for MariaDB-only client options

[client-mariadb]

default-character-set=utf8
~
~
~
~
~
~
~
"/etc/my.cnf.d/client.cnf" 17L, 351C                          1,1           All

systemctl restart mariadb.service

4.登录验证是否生效

[root@ZABBIX ~]# mysql -uroot -p
Enter password: 

MariaDB [(none)]> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)