CentOS で MySQL が起動しない場合に行った対処メモ

/etc/rc.d/init.d/mysqld start
MySQL データベースを初期化中:  Installing MySQL system tables...
110814  3:25:38 [ERROR] /usr/libexec/mysqld: unknown variable 'default-character-set=utf8'
110814  3:25:38 [ERROR] Aborting
 
110814  3:25:38 [Note] /usr/libexec/mysqld: Shutdown complete
 
 
Installation of system tables failed!  Examine the logs in
/var/lib/mysql for more information.
 
You can try to start the mysqld daemon with:
 
    shell> /usr/libexec/mysqld --skip-grant &
 
and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:
 
    shell> /usr/bin/mysql -u root mysql
    mysql> show tables
 
Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /var/lib/mysql that may be helpful.
 
Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.
 
Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!
 
                                                           [失敗]

/usr/bin/mysql_install_db
chown -R mysql:mysql /var/lib/mysql/*
chmod 755 /var/lib/mysql/*

vi /var/log/mysqld.log

[ERROR] /usr/libexec/mysqld: unknown variable 'default-character-set=utf8'