标签 mysql无法启动 下的文章

Centos

Mysql数据库从mysql5.1升级到mysql5.5以后无法启动,查看日志,发现有以下日志

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

170112  8:19:12 [ERROR] Aborting

修改:vi /etc/my.cnf配置文件

[mysqld]

port=3306

default-character-set = utf8

character_set_server = utf8

改为

port=3306

#default-character-set = utf8(注释掉)

character_set_server = utf8

再重启就OK了