1.Login msyql command mode and query mysql check character below

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 again

share: Change charset in MySQL 5.5 with my.cnf