1 查看字符集
    show variables like ‘character%’;
    show variables like ‘%char%’;
    2.修改
    [client]
    password =123456
    port =3306
    default-character-set=utf8
    [mysqld]
    port =3306
    character_set_server=utf8
    character_set_client=utf8
    collation-server=utf8_general_ci
    #(注意linux下mysql安装完后是默认：表名区分大小写,列名不区分大小写;0:区分大小写,1:不区分大小写)
    lower_case_table_names=1
    #(设置最大连接数,默认为151,Mysql服务器允许的最大连接数16384;)
    max_connections=1000
    [mysql]
    default-character-set= utf8