mysql5.6.26修改数据库字符集_Linux013Centosmysql5.6.50修改字符集为utf8

# 查看数据库字符集

mysql > show variables like &＃39;character%&＃39;;

# 先将 mysql 服务停止&＃xff0c;然后继续后续操作

# 数据库停止

systemctl stop mysqld.service

# 查看数据库状态

systemctl status mysqld.service

# 修改数据库字符集

vi /etc/my.cnf

[client]

default-character-set &＃61; utf8

[mysql]

default-character-set &＃61; utf8

[mysqld]

character-set-client-handshake &＃61; FALSE

character-set-server &＃61; utf8

collation-server &＃61; utf8_unicode_ci

init_connect&＃61;&＃39;SET NAMES utf8&＃39;

# 数据库启动

systemctl start mysqld.service

# 查看数据库字符集

mysql > show variables like &＃39;character%&＃39;;