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了