LNMP1.3突然出现数据库服务无法启动，求助军哥。

龙腾宇内

今天执行lnmp restart时，数据库服务无法启动，期间没有修改过其他任何东西。不知道为什么。我把错误信息发上来，麻烦军哥帮忙瞧瞧。

1. root@digitalocean:~# lnmp restart
   
2. +-------------------------------------------+
   
3. |    Manager for LNMP, Written by Licess    |
   
4. +-------------------------------------------+
   
5. |              http://lnmp.org              |
   
6. +-------------------------------------------+
   
7. Stoping LNMP...
   
8. Stoping nginx...  done
   
9. [ ok ] Stopping mysql (via systemctl): mysql.service.
   
10. Gracefully shutting down php-fpm . done
    
11. Starting LNMP...
    
12. Starting nginx...  done
    
13. [....] Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
    
14. failed!
    
15. Starting php-fpm  done
    
16. root@digitalocean:~# systemctl status mysql.service
    
17. ● mysql.service - LSB: start and stop MySQL
    
18.    Loaded: loaded (/etc/init.d/mysql)
    
19.    Active: failed (Result: exit-code) since Sat 2016-09-10 12:40:08 CST; 33s ago
    
20.   Process: 3220 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
    
21. 
    
22. Sep 10 12:40:06 digitalocean systemd[1]: Starting LSB: start and stop MySQL...
    
23. Sep 10 12:40:06 digitalocean mysql[3220]: Starting MySQL
    
24. Sep 10 12:40:08 digitalocean mysql[3220]: ..The server quit without updating PID file (/usr/local/mysql/var/digitalocean....ailed!
    
25. Sep 10 12:40:08 digitalocean systemd[1]: mysql.service: control process exited, code=exited status=1
    
26. Sep 10 12:40:08 digitalocean systemd[1]: Failed to start LSB: start and stop MySQL.
    
27. Sep 10 12:40:08 digitalocean systemd[1]: Unit mysql.service entered failed state.
    
28. Hint: Some lines were ellipsized, use -l to show in full.
    
29. root@digitalocean:~#

复制代码

执行journalctl -xn显示如下信息：

1. root@digitalocean:~# journalctl -xn
   
2. -- Logs begin at Wed 2016-08-03 19:00:26 CST, end at Sat 2016-09-10 12:45:42 CST. --
   
3. Sep 10 12:45:36 digitalocean sshd[3782]: Failed password for root from 116.31.116.26 port 48647 ssh2
   
4. Sep 10 12:45:37 digitalocean sshd[3782]: Received disconnect from 116.31.116.26: 11:  [preauth]
   
5. Sep 10 12:45:37 digitalocean sshd[3782]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=116.31.116
   
6. Sep 10 12:45:38 digitalocean sshd[3784]: Failed password for invalid user divya from 192.169.245.28 port 37234 ssh2
   
7. Sep 10 12:45:38 digitalocean sshd[3784]: pam_unix(sshd:auth): check pass; user unknown
   
8. Sep 10 12:45:40 digitalocean sshd[3784]: Failed password for invalid user divya from 192.169.245.28 port 37234 ssh2
   
9. Sep 10 12:45:40 digitalocean sshd[3784]: pam_unix(sshd:auth): check pass; user unknown
   
10. Sep 10 12:45:42 digitalocean sshd[3784]: Failed password for invalid user divya from 192.169.245.28 port 37234 ssh2
    
11. Sep 10 12:45:42 digitalocean sshd[3784]: Connection closed by 192.169.245.28 [preauth]
    
12. Sep 10 12:45:42 digitalocean sshd[3784]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=ip-192-169
    
13. lines 1-11/11 (END)

复制代码

麻烦军哥帮忙看看。非常感谢。

licess

按反馈必读提供mysql日志