mysql配置

1.修改mysql配置文件

vim /etc/my.cnf

2.添加配置

[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

3.重启mysql

systemctl restart mysqld

4.查看mysql配置

show variables like '%char%';

5.查看mysql字符集

show variables like '%collation%';

6.查看mysql版本

select version();

7.查看mysql编码

show variables like '%character%';