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%';