MySQL错误和随机崩溃

随机昨晚我的MySQL服务器完全closures….从地球的脸上掉落。

以下是我尝试loginphpmyadmin时发生的情况

https://i.gyazo.com/a106c8b61c88adb7c88d3aabd98a861c.png

困惑,我把我的服务器,并做了“MySQL – ”。 这是回应:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 

嗯奇怪我想。 这一定是因为mysql没有运行。 我继续尝试通过“服务mysql启动”来启动服务。 这是回应:

 Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details. 

然后我意识到有什么事情搞砸了。 我做了这两个命令,下面是这些回应:

systemctl状态mysql.service

 ● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en Drop-In: /etc/systemd/system/mysql.service.d └─open_files_limit.conf Active: activating (start-post) (Result: exit-code) since Tue 2017-10-03 12:2 Process: 6971 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE) Process: 6964 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exit Main PID: 6971 (code=exited, status=1/FAILURE); : 6972 (mysql-systemd-s CGroup: /system.slice/mysql.service └─control ├─6972 /bin/bash /usr/share/mysql/mysql-systemd-start post └─6999 sleep 1 Oct 03 12:23:29 localhost systemd[1]: Starting MySQL Community Server... Oct 03 12:23:30 localhost systemd[1]: mysql.service: Main process exited, code=e lines 1-15/15 (END) 

journalctl -xe

 -- Subject: Unit mysql.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysql.service has failed. -- -- The result is failed. Oct 03 12:24:30 localhost systemd[1]: mysql.service: Unit entered failed state. Oct 03 12:24:30 localhost systemd[1]: mysql.service: Failed with result 'exit-code'. Oct 03 12:24:30 localhost systemd[1]: mysql.service: Service hold-off time over, scheduling restart. Oct 03 12:24:30 localhost systemd[1]: Stopped MySQL Community Server. -- Subject: Unit mysql.service has finished shutting down -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysql.service has finished shutting down. Oct 03 12:24:30 localhost systemd[1]: Starting MySQL Community Server... -- Subject: Unit mysql.service has begun start-up -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit mysql.service has begun starting up. Oct 03 12:24:31 localhost systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE 

任何想法,我到底在做什么错了? 评论,如果你需要更多的信息!