centos7下重启MySQL5.7.19报错SSL error ；Fatal error

最新推荐文章于 2022-12-13 16:58:16 发布

chichentang1598

最新推荐文章于 2022-12-13 16:58:16 发布

阅读量349

点赞数

原文链接：https://my.oschina.net/u/3041278/blog/1490504

版权

重启mysql

[root@yuhai ~]# systemctl restart mysqld
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.

按照提示查看原因

[root@yuhai ~]# systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: deactivating (final-sigterm) (Result: exit-code)
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 9452 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
  Process: 9434 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/mysqld.service
           └─9455 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

Jul 27 15:02:23 yuhai.com systemd[1]: Starting MySQL Server...
Jul 27 15:02:23 yuhai.com mysqld[9452]: Initialization of mysqld failed: 0
Jul 27 15:02:23 yuhai.com systemd[1]: mysqld.service: control process exited, code=exited status=1

没有看出原因，查看MySQL日志

[root@yuhai ~]# cat /var/log/mysqld.log |grep [ERROR]
***以上无关省略***
[ERROR] SSL error: Unable to get certificate from 'server-cert.pem'
[ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'user'
***以下无关省略***

希望有哪位大牛路过指点迷津。

转载于:https://my.oschina.net/u/3041278/blog/1490504