CentOS 7 安装MySQL 7 并设置 utf8mb4

1. 配置YUM

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

yum localinstall mysql57-community-release-el7-8.noarch.rpm

yum repolist enabled | grep "mysql.*-community.*"

yum install mysql-community-server

2. 设置开机启动

systemctl enable mysqld
systemctl daemon-reload

3. 修改密码

mysql安装完成之后，/var/log/mysqld.log文件中给root生成了一个默认密码。

通过下面的方式找到root默认密码，然后登录mysql进行修改：

grep 'temporary password' /var/log/mysqld.log

mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED BY 'SaxingNewPass123!';

systemctl restart mysqld

4. 设置编码为utf8mb4

vim /etc/my.cnf

需要手动添加上[client]和[mysql]。

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'

systemctl restart mysqld

查看结果

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';