Stránka 1 z 1

MySQL problém

Napsal: 08 pro 2017 21:47
od lulak
Čaute mám takovej problém a nevím co s tím hledal jsem řešení i na stackoverflow a dalších pomocných forech ale bez výsledku.Můžete mi prosím pomoct ?
po zadání příkazu service mysql start my to vypíše:

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

po zadání systemctl status mysql.service zase:

● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Fri 2017-12-08 20:22:40 GMT; 28s ago
Process: 2537 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)
Process: 2502 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)

pro 08 20:22:40 linux systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
pro 08 20:22:40 linux systemd[1]: mysql.service: Scheduled restart job, restart counter is at 6.
pro 08 20:22:40 linux systemd[1]: Stopped MySQL Community Server.
pro 08 20:22:40 linux systemd[1]: mysql.service: Start request repeated too quickly.
pro 08 20:22:40 linux systemd[1]: mysql.service: Failed with result 'exit-code'.
pro 08 20:22:40 linux systemd[1]: Failed to start MySQL Community Server.


po zadání příkazu journalctl -xe:

-- Unit mysql.service has finished shutting down.
pro 08 20:42:52 HEXX-MACHINE systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mysql.service has begun starting up.
pro 08 20:42:54 HEXX-MACHINE mysqld[4230]: 2017-12-08T20:42:54.105602Z 0 [ERROR] Failed to start mysqld daemon. Check mysqld error log.
pro 08 20:42:54 HEXX-MACHINE systemd[1]: mysql.service: Control process exited, code=exited status=1
pro 08 20:42:54 HEXX-MACHINE systemd[1]: mysql.service: Failed with result 'exit-code'.
pro 08 20:42:54 HEXX-MACHINE systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mysql.service has failed.
--
-- The result is RESULT.
pro 08 20:42:54 HEXX-MACHINE systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
pro 08 20:42:54 HEXX-MACHINE systemd[1]: mysql.service: Scheduled restart job, restart counter is at 2.
-- Subject: Automatic restarting of a unit has been scheduled
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Automatic restarting of the unit mysql.service has been scheduled, as the result for
-- the configured Restart= setting for the unit.
pro 08 20:42:54 HEXX-MACHINE systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mysql.service has finished shutting down.
pro 08 20:42:54 HEXX-MACHINE systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mysql.service has begun starting up.


Prosím pomoc :?

Re: MySQL problém

Napsal: 25 úno 2018 10:57
od milsimr
Hoď sem obsah mysqld logu. Nicméně, pokud v tom nemáš žádná data, tak by asi bylo nejjednodušší celé MySQL přeinstalovat.