If you want to change default character set in Mysql then first you have to open my.cnf file with below command:
vi /etc/my.cnf
in this file you have to add below line:
default-character-set=utf8
Under [mysqld] add below lines too:
default-character-set=utf8
init_connect=’SET NAMES utf8′...