ubuntu16.04下修改mysql字符集

1. 使用如下命令找到mysql的配置文件

            $ find / -name my.cnf | grep /mysql*/my.cnf    

2. 修改配置文件为:

            !includedir /etc/mysql/conf.d/        !includedir /etc/mysql/mysql.conf.d/        [mysqld]        character_set_server=utf8        [mysql]        default-character-set=utf8    

3. 重启mysql

            $ service mysql restart    

4. 进入数据查看字符集

            mysql> show variables like 'character%';