快速安装MySQL与为Lapis修改mysql字符集

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server

systemctl start  mysqld.service
systemctl status mysqld.service

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
grant all on *.* to root@'%' identified by 'password';

show variables like '%char%';  
set character_set_connection=gbk;
set character_set_client=gbk;
set character_set_results=gbk;

[mysqld]
#default-character-set = utf8
init-connect='SET NAMES utf8'
character-set-server = utf8

[mysql]
default-character-set = utf8

SET NAMES utf8

SET character_set_client = utf8;
SET character_set_results = utf8;
SET character_set_connection = utf8;