Question

linux mysql启动出错MySQL Daemon failed to start. 求大神帮忙看下,公司已经上线的服务器,很急

[root@localhost ~]# service mysqld startMySQL Daemon failed to start.Starting mysqld: [FAILED]下面是我查看错误日志的信息:

Answer 1

备份下/usr/share/mysql/charsets/Index.xml；
然后尝试把配置文件/usr/share/mysql/charsets/Index.xml中的utf8编码改为utf8mb4即可，修改方法如下：
[修改前：]
<charset name="utf8">
<family>Unicode</family>
<description>UTF-8 Unicode</description>
<alias>utf-8</alias>
<collation name="utf8_general_ci" id="33">
<flag>primary</flag>
<flag>compiled</flag>
</collation>
<collation name="utf8_bin" id="83">
<flag>binary</flag>
<flag>compiled</flag>
</collation>
</charset>

[修改后：]
<charset name="utf8mb4">
<family>Unicode</family>
<description>UTF-8 Unicode</description>
<alias>utf-8</alias>
<collation name="utf8_general_ci" id="33">
<flag>primary</flag>
<flag>compiled</flag>
</collation>
<collation name="utf8_bin" id="83">
<flag>binary</flag>
<flag>compiled</flag>
</collation>
</charset>
再重启mysqld

追问

改了之后还是一样的错误,,日志也一样