Mysql set character set utf-8

[client]

default-character-set = utf8

[mysqld]

skip-external-locking

character-set-client-handshake=FALSE

init_connect=SET collation_connection = utf8_unicode_ci

init_connect=SET NAMES utf8

character-set-server = utf8

collation-server = utf8_unicode_ci

[mysqldump]

default-character-set = utf8

[mysql]

default-character-set = utf8

Server version: 5.5.46-0ubuntu0.14.04.2 (Ubuntu)