centos7 mysql libssl_centos7下重启MySQL5.7.19报错SSL error ;Fatal error

重启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'

***以下无关省略***

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值