vndrussia
@vndrussia
Вроде разработчик,а вроде и нет

Не запускается MYSQL сервис?

Сервер был жестко перезагружен после чего в PHPMYADMIN выдает такую ошибку при логине.
5dd64612c289e045648027.png
Лог запуска MYSQL
root@orangepilite:~# systemctl status mysql.service
* mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: activating (start-post) (Result: exit-code) since Thu 2019-11-21 11:00:48 MSK; 28s ago
  Process: 20448 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
  Process: 20423 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 20448 (code=exited, status=1/FAILURE);         : 20449 (mysql-systemd-s)
   CGroup: /system.slice/mysql.service
           `-control
             |-20449 /bin/bash /usr/share/mysql/mysql-systemd-start post
             `-21655 sleep 1

Nov 21 11:00:48 orangepilite systemd[1]: Starting MySQL Community Server...
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.197680Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.198100Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.400991Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.409441Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.16.04.1) starti
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.427573Z 0 [ERROR] Could not open file '/var/log/mysql/error.log' for erro
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.427713Z 0 [ERROR] Aborting
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.427819Z 0 [Note] Binlog end
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.428206Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
Nov 21 11:00:49 orangepilite systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
...skipping...
* mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: activating (start-post) (Result: exit-code) since Thu 2019-11-21 11:00:48 MSK; 28s ago
  Process: 20448 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
  Process: 20423 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 20448 (code=exited, status=1/FAILURE);         : 20449 (mysql-systemd-s)
   CGroup: /system.slice/mysql.service
           `-control
             |-20449 /bin/bash /usr/share/mysql/mysql-systemd-start post
             `-21655 sleep 1

Nov 21 11:00:48 orangepilite systemd[1]: Starting MySQL Community Server...
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.197680Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.198100Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.400991Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.409441Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.16.04.1) starti
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.427573Z 0 [ERROR] Could not open file '/var/log/mysql/error.log' for erro
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.427713Z 0 [ERROR] Aborting
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.427819Z 0 [Note] Binlog end
Nov 21 11:00:49 orangepilite mysqld[20448]: 2019-11-21T08:00:49.428206Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
Nov 21 11:00:49 orangepilite systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Что с этим сделать и как решить?Подскажите пожалуйста.
  • Вопрос задан
  • 2708 просмотров
Решения вопроса 1
@vitaly_il1
DevOps Consulting
/var/log/mysql/ должен быть writable for mysql user
Ответ написан
Комментировать
Пригласить эксперта
Ваш ответ на вопрос

Войдите, чтобы написать ответ

Похожие вопросы