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

Question

Answer 1

提问者 qq_相濡_7 2019-07-04 15:36:52

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.

Answer 2

编程浪子 2019-07-03 17:12:13

你好

执行启动命令失败后 

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

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

Answer 3

编程浪子 2019-07-03 12:59:20

你好

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

• 提问者 qq_相濡_7 #1

  [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 ~]#