mysql: Character set 'gbk' is not a compiled character set and is not...

wgkgood

一、Mysql初始化及各种操作报错如下：
mysql: Character set 'gbk' is not a compiled character set and is
not specified in the '/opt/mysql/share/mysql/charsets/Index.xml'  file
Character set 'utf8mb4' is not a compiled character set
Character set 'utf-8 is not a compiled character set
Character set 'gb2312' is not a compiled character set
二、解决办法：
在mysql配置文件/etc/my.cnf里面的[client]里面加入：
default-character-set=utf8
即可，然后再执行相应的mysql命令，错误消失。