mysqld 启动失败,查看日志出现如下错误,怎么解决,谢谢?

来源:8-1 Mysql安装及链接

qq_相濡_7

2019-07-02

图片描述

写回答

3回答

qq_相濡_7

提问者

2019-07-04

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.

[root@localhost ~]# systemctl status mysqld.service

● mysqld.service - MySQL Server

   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

   Active: failed (Result: exit-code) since Thu 2019-07-04 03:34:24 EDT; 28s ago

     Docs: man:mysqld(8)

           http://dev.mysql.com/doc/refman/en/using-systemd.html

  Process: 2191 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)

  Process: 2168 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

 Main PID: 2191 (code=exited, status=1/FAILURE)

   Status: "SERVER_BOOTING"


Jul 04 03:34:22 localhost.localdomain systemd[1]: Starting MySQL Server...

Jul 04 03:34:24 localhost.localdomain systemd[1]: mysqld.service: main process exited, code=exi...RE

Jul 04 03:34:24 localhost.localdomain systemd[1]: Failed to start MySQL Server.

Jul 04 03:34:24 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state.

Jul 04 03:34:24 localhost.localdomain systemd[1]: mysqld.service failed.

Hint: Some lines were ellipsized, use -l to show in full.

[root@localhost ~]# 



[root@localhost ~]# journalctl -xe

-- 

-- Unit session-1.scope has begun starting up.

Jul 04 03:33:48 localhost.localdomain sshd[2126]: pam_unix(sshd:session): session opened for user ro

Jul 04 03:34:22 localhost.localdomain polkitd[621]: Registered Authentication Agent for unix-process

Jul 04 03:34:22 localhost.localdomain systemd[1]: Starting MySQL Server...

-- Subject: Unit mysqld.service has begun start-up

-- Defined-By: systemd

-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

-- 

-- Unit mysqld.service has begun starting up.

Jul 04 03:34:24 localhost.localdomain systemd[1]: mysqld.service: main process exited, code=exited, 

Jul 04 03:34:24 localhost.localdomain systemd[1]: Failed to start MySQL Server.

-- Subject: Unit mysqld.service has failed

-- Defined-By: systemd

-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

-- 

-- Unit mysqld.service has failed.

-- 

-- The result is failed.

Jul 04 03:34:24 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state.

Jul 04 03:34:24 localhost.localdomain systemd[1]: mysqld.service failed.


0
0

编程浪子

2019-07-03

你好

执行启动命令失败后 

执行 systemctl status mysqld.service  把内容都复制出来(保持好格式,千万不要一行,不然看不懂了)

再执行 journalctl -xe 把内容都复制出来(保持好格式,千万不要一行,不然看不懂了)

0
0

编程浪子

2019-07-03

你好

麻烦你执行启动命令,我看看启动命令报错是什么?

0
1
qq_相濡_7
[root@localhost ~]# 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. [root@localhost ~]#
2019-07-03
共1条回复

快速上手Linux 玩转典型应用

以主流CentOS 7 操作系统为例,系统讲解Linux,真实线上环境助你快速上手,独立配置运维服务器

1663 学习 · 572 问题

查看课程