问题如下:
    image.png
    image.png

    解决:
    1.先查看字符集
    show variables like ‘char%’;
    image.png
    将 character_set_database 和 character_set_server 设置为utf-8

    ====================================================
    image.png

    [client]
    default-character-set=utf8
    image.png

    default-storage-engine=INNODB
    character-set-server=utf8
    collation-server=utf8_general_ci
    [mysql]
    default-character-set=utf8

    image.png

    image.png


    [mysql]
    default-character-set=utf8
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    symbolic-links=0
    default-character-set=utf8
    character_set_server=utf8
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    default-character-set=utf8
    [mysql.server]
    default-character-set=utf8
    [client]
    default-character-set=utf8

    [client]
    default-character-set=utf8

    **[mysql]
    default-character-set=utf8

    [mysqld]
    init_connect=’SET collation_connection = utf8_unicode_ci’
    init_connect=’SET NAMES utf8’
    character-set-server=utf8
    collation-server=utf8_unicode_ci
    skip-character-set-client-handshake**

    docker cp /usr/mysql.cnf /etc/my.cnf.d/mysql.cnf

    (失败了!)