やきにくとくにきや

WEBサービスとイベントに夢見るエンジニアの技術メモ、チラシの裏。そして焼肉たべたい

unknown variable 'default-character-set=utf8'

   

[default]
131204 13:38:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131204 13:38:30 [Note] Plugin 'FEDERATED' is disabled.
131204 13:38:30 InnoDB: The InnoDB memory heap is disabled
131204 13:38:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131204 13:38:30 InnoDB: Compressed tables use zlib 1.2.3
131204 13:38:30 InnoDB: Using Linux native AIO
131204 13:38:30 InnoDB: Initializing buffer pool, size = 128.0M
131204 13:38:30 InnoDB: Completed initialization of buffer pool
131204 13:38:30 InnoDB: highest supported file format is Barracuda.
131204 13:38:30 InnoDB: Waiting for the background threads to start
131204 13:38:31 InnoDB: 5.5.34 started; log sequence number 20584055
131204 13:38:31 [ERROR] /usr/libexec/mysqld: unknown variable 'default-character-set=utf8'
131204 13:38:31 [ERROR] Aborting

131204 13:38:31 InnoDB: Starting shutdown...
131204 13:38:32 InnoDB: Shutdown completed; log sequence number 20584055
131204 13:38:32 [Note] /usr/libexec/mysqld: Shutdown complete

131204 13:38:32 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pida ended
[/default]
ここのところ
[default]
/usr/libexec/mysqld: unknown variable 'default-character-set=utf8'
[/default]
MySQL5.5から default-character-set が廃止されて character-set-server を使うようになった模様

MySQL 5.5ではdefault-character-setが廃止されてた…
http://www.indigo-design.org/2012/01/mysql-5-5-default-character-set/

/etc/my.cnf を

default-character-set=utf8

default-character-set=utf8

以下のように書き換えてMySQLを起動でOK

 - MySQL