mysql-5.6.26修改数据库字符集_Linux-013-Centos mysql 5.6.50 修改字符集为 utf8

# 查看数据库字符集

mysql > show variables like 'character%';

# 先将 mysql 服务停止，然后继续后续操作

# 数据库停止

systemctl stop mysqld.service

# 查看数据库状态

systemctl status mysqld.service

# 修改数据库字符集

vi /etc/my.cnf

[client]

default-character-set = utf8

[mysql]

default-character-set = utf8

[mysqld]

character-set-client-handshake = FALSE

character-set-server = utf8

collation-server = utf8_unicode_ci

init_connect='SET NAMES utf8'

# 数据库启动

systemctl start mysqld.service

# 查看数据库字符集

mysql > show variables like 'character%';