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
Short link: http://taxze.com/?p=102
Canonical link: http://www.taxze.com/change-charset-in-mysql-5-5-with-my-cnf/
Leave a Reply “Change charset in MySQL 5.5 with my.cnf”