Linux-安装mysql出现问题-启动服务器失败

环境

centos7.3 想要安装mysql5.7

启动mysql服务失败

service mysqld  restart
Redirecting to /bin/systemctl restart  mysqld.service
Job for mysqld.service failed because the control process exited with error code. 
See "systemctl status mysqld.service" and "journalctl -xe" for details.

解决办法

查看mysql服务状态
systemctl status mysqld.service

结果如下

 mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Tue 2019-08-06 00:00:53 CST; 4min 32s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 18915 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
  Process: 18892 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 18282 (code=exited, status=1/FAILURE)

Aug 06 00:00:52 iZuf6fx717wv2o5sdh8q9hZ systemd[1]: Starting MySQL Server...
Aug 06 00:00:52 iZuf6fx717wv2o5sdh8q9hZ mysqld_pre_systemd[18892]: 2019-08-05T16:00:52.439714Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --ex...details).
Aug 06 00:00:52 iZuf6fx717wv2o5sdh8q9hZ mysqld_pre_systemd[18892]: 2019-08-05T16:00:52.441176Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
Aug 06 00:00:52 iZuf6fx717wv2o5sdh8q9hZ mysqld_pre_systemd[18892]: 2019-08-05T16:00:52.441194Z 0 [ERROR] Aborting
Aug 06 00:00:53 iZuf6fx717wv2o5sdh8q9hZ systemd[1]: mysqld.service: control process exited, code=exited status=1
Aug 06 00:00:53 iZuf6fx717wv2o5sdh8q9hZ systemd[1]: Failed to start MySQL Server.
Aug 06 00:00:53 iZuf6fx717wv2o5sdh8q9hZ systemd[1]: Unit mysqld.service entered failed state.
Aug 06 00:00:53 iZuf6fx717wv2o5sdh8q9hZ systemd[1]: mysqld.service failed.
Hint: Some lines were ellipsized, use -l to show in full.

罪魁祸首
错误

  1. 查看数据文件,数据文件存在,被占用
    cd /var/lib/mysql

在这里插入图片描述
2.备份 mv mysql mysql.bak

3.重启服务 service mysqld restart

在这里插入图片描述

成功!!!
评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值