I had to make a system restore from a backup because of a hard disk failure. I did that manually but the db is failing to start.
From the /var/lib/mysql/domain.err file i have the following
and from the systemctl start
From the /var/lib/mysql/domain.err file i have the following
Bash:
2020-12-05T23:50:19.661984Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.32' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL)
2020-12-05T23:50:19.735641Z 2 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:50:19.765721Z 3 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:50:19.768840Z 4 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:50:19.769488Z 5 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:50:19.835821Z 8 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:51:42.357682Z 12 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:51:44.932140Z 13 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:51:44.933143Z 14 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:52:44.445352Z 20 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO)
2020-12-05T23:52:59.669083Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-12-05T23:52:59.669099Z 0 [Note] Shutting down slave threads
Bash:
[[email protected] 2020-12-04]# systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mysqld.service.d
└─limits.conf
Active: failed (Result: start-limit) since Sun 2020-12-06 01:34:50 CET; 6s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 15080 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=203/EXEC)
Process: 15058 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 6962 (code=exited, status=0/SUCCESS)
Dec 06 01:34:50 first.overronet.com systemd[1]: Failed to start MySQL Server.
Dec 06 01:34:50 first.overronet.com systemd[1]: Unit mysqld.service entered failed state.
Dec 06 01:34:50 first.overronet.com systemd[1]: mysqld.service failed.
Dec 06 01:34:50 first.overronet.com systemd[1]: mysqld.service holdoff time over, scheduling restart.
Dec 06 01:34:50 first.overronet.com systemd[1]: Stopped MySQL Server.
Dec 06 01:34:50 first.overronet.com systemd[1]: start request repeated too quickly for mysqld.service
Dec 06 01:34:50 first.overronet.com systemd[1]: Failed to start MySQL Server.
Dec 06 01:34:50 first.overronet.com systemd[1]: Unit mysqld.service entered failed state.
Dec 06 01:34:50 first.overronet.com systemd[1]: mysqld.service failed.
Last edited by a moderator: