MySQL 5.7.27无法启动

Question

我刚刚在Centos 7上安装了MySQL 5.7.23。一旦我安装了systemctl，mysqld就会给我一个错误。使systemctl状态mysqld返回：

●�mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
���Active: failed�(Result: start-limit) since Tue 2019-08-27 02:55:20 CEST; 11min ago
�����Docs: man:mysqld(8)
  ���������http://dev.mysql.com/doc/refman/en/using-systemd.html
��Process: 11299 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
��Process: 11281 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

Aug 27 02:55:20 server0-centos7 systemd[1]: mysqld.service: control process exited, code=exited status=1
Aug 27 02:55:20 server0-centos7 systemd[1]: Failed to start MySQL Server.
Aug 27 02:55:20 server0-centos7 systemd[1]: Unit mysqld.service entered failed state.
Aug 27 02:55:20 server0-centos7 systemd[1]: mysqld.service failed.
Aug 27 02:55:20 server0-centos7 systemd[1]: mysqld.service holdoff time over, scheduling restart.
Aug 27 02:55:20 server0-centos7 systemd[1]: Stopped MySQL Server.
Aug 27 02:55:20 server0-centos7 systemd[1]: start request repeated too quickly for mysqld.service
Aug 27 02:55:20 server0-centos7 systemd[1]: Failed to start MySQL Server.
Aug 27 02:55:20 server0-centos7 systemd[1]: Unit mysqld.service entered failed state.
Aug 27 02:55:20 server0-centos7 systemd[1]: mysqld.service failed.

Answer 1

这个问题可能有各种各样的原因。

1. 所需的文件夹权限可能不存在。

请在这里找到与文件夹权限相关的答案。

Job for mysqld.service failed in Centos 7

1. 当MySQL服务停止时，您的空闲内存可能会更少，所以只要运行：

系统启动mysqld

MySQL正在尝试利用比可用的更多的东西，因为它无法这样做，所以失败了。

对于数据库驱动的网站，我建议至少1GB的RAM最低.如果您仍然希望以更少的内存运行，那么我推荐NGINX而不是Apache。