mysql 字符集修改

启动报错：Starting MySQL… ERROR! The server quit without updating PID file

日志报错：[ERROR] /usr/local/mysql/bin/mysqld: unknown variable ‘default-character-set=gbk’

参考https://blog.youkuaiyun.com/vah101/article/details/6365120

default-character-set=gbk在[client]里面是认得，而在[mysqld]里面不认了，
5.5 以后好像不认 default-character-set
用character_set_server=gbk

查看mysql字符集：
mysql> show variables like ‘character%’;
临时修改mysql的字符集：通过navicat 修改字符集，重新连接数据库后，字符集会恢复默认，不明白有什么用

//修改全局字符集

set character_set_connection=gbk;
set character_set_database=gbk;
set character_set_results=gbk;
set character_set_server=gbk;
set character_set_system=gbk;
set collation_connection=gbk;
set collation_database=gbk;
set collation_server=gbk;