启动mysql出问题。卡住了。

Question

[root@VM_0_6_centos ~]# 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@VM_0_6_centos ~]# systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; bad; vendor preset: disabled)
   Active: failed (Result: exit-code) since Sat 2019-06-08 22:15:41 CST; 1min 0s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 20763 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)
  Process: 20740 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 20763 (code=exited, status=1/FAILURE)
   Status: "SERVER_BOOTING"
    Error: 2 (No such file or directory)

Jun 08 22:15:40 VM_0_6_centos systemd[1]: Starting MySQL Server...
Jun 08 22:15:41 VM_0_6_centos systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
Jun 08 22:15:41 VM_0_6_centos systemd[1]: Failed to start MySQL Server.
Jun 08 22:15:41 VM_0_6_centos systemd[1]: Unit mysqld.service entered failed state.
Jun 08 22:15:41 VM_0_6_centos systemd[1]: mysqld.service failed.
[root@VM_0_6_centos ~]# journalctl -xe
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit session-7449.scope has finished starting up.
-- 
-- The start-up result is done.
Jun 08 22:24:01 VM_0_6_centos CROND[21473]: (root) CMD (/usr/local/qcloud/stargate/admin/start.sh > /dev/null 2>&1 &)
Jun 08 22:24:15 VM_0_6_centos sshd[21507]: Invalid user mongo from 186.235.221.24 port 36713
Jun 08 22:24:15 VM_0_6_centos sshd[21507]: input_userauth_request: invalid user mongo [preauth]
Jun 08 22:24:15 VM_0_6_centos sshd[21507]: pam_unix(sshd:auth): check pass; user unknown
Jun 08 22:24:15 VM_0_6_centos sshd[21507]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=186.235.221.2
Jun 08 22:24:17 VM_0_6_centos sshd[21507]: Failed password for invalid user mongo from 186.235.221.24 port 36713 ssh2
Jun 08 22:24:18 VM_0_6_centos sshd[21507]: Received disconnect from 186.235.221.24 port 36713:11: Bye Bye [preauth]
Jun 08 22:24:18 VM_0_6_centos sshd[21507]: Disconnected from 186.235.221.24 port 36713 [preauth]
Jun 08 22:24:32 VM_0_6_centos sshd[21527]: Invalid user superstage from 212.64.87.81 port 59510
Jun 08 22:24:32 VM_0_6_centos sshd[21527]: input_userauth_request: invalid user superstage [preauth]
Jun 08 22:24:32 VM_0_6_centos sshd[21527]: pam_unix(sshd:auth): check pass; user unknown
Jun 08 22:24:32 VM_0_6_centos sshd[21527]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=212.64.87.81
Jun 08 22:24:34 VM_0_6_centos sshd[21527]: Failed password for invalid user superstage from 212.64.87.81 port 59510 ssh2
Jun 08 22:24:34 VM_0_6_centos sshd[21527]: Received disconnect from 212.64.87.81 port 59510:11: Bye Bye [preauth]
Jun 08 22:24:34 VM_0_6_centos sshd[21527]: Disconnected from 212.64.87.81 port 59510 [preauth]
Jun 08 22:25:01 VM_0_6_centos systemd[1]: Started Session 7450 of user root.
-- Subject: Unit session-7450.scope has finished start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit session-7450.scope has finished starting up.
-- 
-- The start-up result is done.
Jun 08 22:25:01 VM_0_6_centos CROND[21554]: (root) CMD (/usr/local/qcloud/stargate/admin/start.sh > /dev/null 2>&1 &)
Jun 08 22:25:21 VM_0_6_centos sshd[21582]: Connection closed by 52.144.86.251 port 42479 [preauth]

Answer 1

编程浪子 2019-06-10 16:21:46

你好

请问你描述的 卡着了 是什么意思？

• 提问者 szuxxy #1

  就是上面我输入启动mysqld的命令，也就是service mysqld restart的命令，但是报了Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details的错。

• 编程浪子 回复 提问者 szuxxy #2

  你好
  请分别执行如下两个命令截图（先执行启动mysql命令在执行如下命令）
  systemctl status mysqld.service
  
  journalctl -xe

• 提问者 szuxxy 回复 编程浪子 #3

  我放到下个问题了,没有注意看老师回答了。[流汗]

点开查看后面2条评论

Answer 2

编程浪子 2019-06-11 14:23:45

你好

你是手动编译安装的还是 ？ 按照课程的示例 执行 yum install 安装的？

如果是yum install 的，在安装过程中又出现什么情况？

• 提问者 szuxxy #1

  就是按照课程示例yum install安装的。遇到了些问题，好像也都解决了。现在看mysql进程是这样的：
  [root@VM_0_6_centos ~]# ps -ef |grep mysql
  root     25130 24837  0 14:46 pts/0    00:00:00 grep --color=auto mysql

• 编程浪子 回复 提问者 szuxxy #2

  我们还是qq聊：1586538192，方便点

• 提问者 szuxxy 回复 编程浪子 #3

  已经申请了。你好，请问美国怎么走？