mysql 数据库字符配置

1修改配置文件

[client]
default-character-set=utf8
 
[mysql]
default-character-set=utf8
[mysqld]
basedir =/usr/local/mysql/mysql
datadir=/usr/local/mysql/mysql/data
socket=/tmp/mysql.sock
user=mysql
port=3306

#character_set_server=utf8
#character_set_client=utf8
#collation_server=utf8_general_ci
character-set-client-handshake = FALSE 
character-set-server = utf8
collation-server = utf8_general_ci 
init_connect=’SET NAMES utf8

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# 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/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d