nick7zmail писал(а): Ср апр 25, 2018 6:58 pm
sudo service mysql enable...
либо сперва disable потом enable
Здравствуйте,
при перезапуске не стартует mysql. Благодаря Вашему совету в прошлый раз сделал:
sudo service mysql start
Всё отлично, но после отключения напряжения система перезагрузилась и опять не запустился сервер sql.
попытка сделать sudo service mysql enable не проходит. Даёт следующие варианты:
sudo service mysql disable
Usage: /etc/init.d/mysql start|stop|restart|reload|force-reload|status|bootstrap
команда
sudo service mysql status
● mariadb.service - MariaDB database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active:
failed (Result: exit-code) since Mon 2018-05-07 13:16:05 MSK; 5min ago
Process: 631 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (
code=exited, status=
Process: 504 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [
Process: 494 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS
Process: 410 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 631 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
May 07 13:16:00 Majordomo_Pi systemd[1]: Starting MariaDB database server...
May 07 13:16:04 Majordomo_Pi mysqld[631]: 2018-05-07 13:16:04 1995943936 [Note] /usr/sbin/mysqld (mysqld 10.1.23-MariaD
May 07 13:16:04 Majordomo_Pi mysqld[631]: 2018-05-07 13:16:04 1995943936 [Warning] Can't create test file /tmp/mysql/Ma
May 07 13:16:05 Majordomo_Pi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
May 07 13:16:05 Majordomo_Pi systemd[1]:
Failed to start MariaDB database server.
May 07 13:16:05 Majordomo_Pi systemd[1]: mariadb.service: Unit entered failed state.
May 07 13:16:05 Majordomo_Pi systemd[1]: mariadb.service: Failed with result 'exit-code'.
lines 1-17/17 (END)
● mariadb.service - MariaDB database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active:
failed (Result: exit-code) since Mon 2018-05-07 13:16:05 MSK; 5min ago
Process: 631 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (
code=exited, status=1/FAILURE)
Process: 504 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VA
Process: 494 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 410 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 631 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
May 07 13:16:00 Majordomo_Pi systemd[1]: Starting MariaDB database server...
May 07 13:16:04 Majordomo_Pi mysqld[631]: 2018-05-07 13:16:04 1995943936 [Note] /usr/sbin/mysqld (mysqld 10.1.23-MariaDB-9+deb9u1) starting as process 631 ...
May 07 13:16:04 Majordomo_Pi mysqld[631]: 2018-05-07 13:16:04 1995943936 [Warning] Can't create test file /tmp/mysql/Majordomo_Pi.lower-test
May 07 13:16:05 Majordomo_Pi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
May 07 13:16:05 Majordomo_Pi systemd[1]:
Failed to start MariaDB database server.
May 07 13:16:05 Majordomo_Pi systemd[1]: mariadb.service: Unit entered failed state.
May 07 13:16:05 Majordomo_Pi systemd[1]: mariadb.service: Failed with result 'exit-code'.
строка
sudo service mysql start
проблему решает до первой перезагрузки. Увы...
Куда копать... Помогите разобраться, лиз
