Для ubuntu 14.04 с отключенным innodb, установленной кодировкой по умолчанию unf8 и немного подправленным конфигом для myisam.
/etc/mysql/my.cnf
[client] port = 3306 socket = /var/run/mysqld/mysqld.sock default-character-set=utf8 [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] character-set-server=utf8 init-connect='SET NAMES utf8;' collation-server=utf8_general_ci user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking skip-networking max_connections=200 bind-address = 127.0.0.1 key_buffer = 36M max_allowed_packet = 1M thread_cache_size = 16 innodb=OFF #ignore-builtin-innodb default-storage-engine = myisam #myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 128M log_error = /var/log/mysql/error.log #expire_logs_days = 10 #max_binlog_size = 100M #innodb_file_per_table = 1 thread_concurrency = 8 myisam_sort_buffer_size = 64M read_rnd_buffer_size = 4M read_buffer_size = 1M sort_buffer_size = 1M table_cache = 1024 key_buffer_size = 512M [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] default-character-set=utf8 [isamchk] key_buffer = 16M write_buffer = 2M read_buffer = 2M sort_buffer_size = 128M key_buffer_size = 128M !includedir /etc/mysql/conf.d/