Mysql5.7无法再次启动

Mysql5.7无法再次启动

这是我一生中第一次拥有 Ubuntu,所以我不太了解该如何管理以及应该寻找什么;我使用的是 18.04 版本。我安装了 MySQL 5.7,它运行了几天,但突然它甚至无法重新启动,无法再次启动(service mysql start或任何东西)......

使用systemctl status mysql.service我得到:

● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor 
preset: enabled)
Active: failed (Result: exit-code) since Thu 2018-07-26 14:24:49 CEST; 
10min ago
Process: 3758 ExecStart=/usr/sbin/mysqld --daemonize --pid- 
file=/run/mysqld/mysqld.pid (code=exited
Process: 3749 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre 
(code=exited, status=0/SUCCESS)

јул 26 14:24:49 maax systemd[1]: mysql.service: Service hold-off 
time over, scheduling restart.
јул 26 14:24:49 maax systemd[1]: mysql.service: Scheduled 
restart 
job, restart counter is at 5.
јул 26 14:24:49 maax systemd[1]: Stopped MySQL Community Server.
јул 26 14:24:49 maax systemd[1]: mysql.service: Start request 
repeated too quickly.
јул 26 14:24:49 maax systemd[1]: mysql.service: Failed with 
result 'exit-code'.
јул 26 14:24:49 maax systemd[1]: Failed to start MySQL Community 
Server.

并使用journalctl -xe我得到:

јул 26 14:24:49 maax systemd[1]: mysql.service: Scheduled 
restart job, restart counter is at 5.
-- Subject: Automatic restarting of a unit has been scheduled
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- Automatic restarting of the unit mysql.service has been scheduled, 
as the result for
-- the configured Restart= setting for the unit.
јул 26 14:24:49 maax systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- Unit mysql.service has finished shutting down.
јул 26 14:24:49 maax systemd[1]: mysql.service: Start request 
repeated too quickly.
јул 26 14:24:49 maax systemd[1]: mysql.service: Failed with 
result 'exit-code'.
јул 26 14:24:49 maax systemd[1]: Failed to start MySQL Community 
Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
-- 
-- Unit mysql.service has failed.
-- 
-- The result is RESULT.

我该怎么做才能修复这个问题并继续正常每天使用 Mysql?

my.cnf 说 error.log 应该在这里:log_error = /var/log/mysql/error.log,但我不再有该文件夹,我不知道为什么,my.cnf 中没有任何变化。现在我再次创建了 mysql 文件夹,但它当然是空的。

当我重新安装 Mysql 时,它运行正常,但是过了一段时间,它又崩溃了......

答案1

看一下这个: https://stackoverflow.com/questions/43440534/mysql-doesn-start-at-all

服务无法正常工作的原因是“mysql.service:启动请求重复太快。”

您能否尝试使用 systemctl:

systemctl stop mysql.service

在那之后:

systemctl start mysql.service

相关内容