mysql不能启动了

guojoa

mysql报错，Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
我重新安装的lnmp1.6，然后将数据库目录指到原目录。还是报这个错误

guojoa

如果执行systemctl status mysql.service
mysql.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
   Active: failed (Result: exit-code) since Fri 2019-08-30 15:50:16 C
     Docs: man:systemd-sysv-generator(8)
  Process: 23291 ExecStop=/etc/init.d/mysql stop (code=exited, status
  Process: 24174 ExecStart=/etc/init.d/mysql start (code=exited, stat

Aug 30 15:50:15 iZ28af1l80eZ systemd[1]: Starting LSB: start and stop
Aug 30 15:50:15 iZ28af1l80eZ mysql[24174]: Starting MySQL
Aug 30 15:50:16 iZ28af1l80eZ mysql[24174]: . * The server quit withou
Aug 30 15:50:16 iZ28af1l80eZ systemd[1]: mysql.service: Control proce
Aug 30 15:50:16 iZ28af1l80eZ systemd[1]: Failed to start LSB: start a
Aug 30 15:50:16 iZ28af1l80eZ systemd[1]: mysql.service: Unit entered
Aug 30 15:50:16 iZ28af1l80eZ systemd[1]: mysql.service: Failed with r


执行journalctl -xe
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-dev
--
-- Unit mysql.service has failed.
--
-- The result is failed.
Aug 30 15:50:16 iZ28af1l80eZ systemd[1]: mysql.service: Unit entered
Aug 30 15:50:16 iZ28af1l80eZ systemd[1]: mysql.service: Failed with r
Aug 30 15:52:37 iZ28af1l80eZ systemd[1]: Starting Cleanup of Temporar
-- Subject: Unit systemd-tmpfiles-clean.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-dev
--
-- Unit systemd-tmpfiles-clean.service has begun starting up.
Aug 30 15:52:37 iZ28af1l80eZ systemd-tmpfiles[24735]: [/usr/lib/tmpfi
Aug 30 15:52:37 iZ28af1l80eZ systemd[1]: Started Cleanup of Temporary
-- Subject: Unit systemd-tmpfiles-clean.service has finished start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-dev
--
-- Unit systemd-tmpfiles-clean.service has finished starting up.
--
-- The start-up result is done.

licess

按反馈必读要求提供mysql日志

guojoa

lnmp1.5的日志在哪里？是数据data文件下吗？

licess

guojoa 发表于 2019-8-30 20:04
lnmp1.5的日志在哪里？是数据data文件下吗？

置顶帖反馈必读里有具体说明