mysql> show variables like "%character%";show variables like "%collation%";
2.edit my.cnf[mysql]
default-character-set=utf8
[mysqld]
collation_server=utf8_general_ci
character_set_server=utf8
3. check charset mysql againmysql> show variables like "%character%";show variables like "%collation%";
2.edit my.cnf[mysql]
default-character-set=utf8
[mysqld]
collation_server=utf8_general_ci
character_set_server=utf8
3. check charset mysql again