Mysql报错,我是视频采集,可能是占用过高,但是重启失败了
执行:
journalctl -xeu mysqld.service
输出:
[root@FirsthandPersonal-VM ~]# journalctl -xeu mysqld.service
-- Defined-By: systemd
-- Support: https://access.redhat.com/support
--
-- Unit mysqld.service has failed.
--
-- The result is RESULT.
Sep 16 02:58:58 FirsthandPersonal-VM systemd[1]: mysqld.service: Service RestartSec=100ms expired, scheduling restart.
Sep 16 02:58:58 FirsthandPersonal-VM systemd[1]: mysqld.service: Scheduled restart job, restart counter is at 25.
-- Subject: Automatic restarting of a unit has been scheduled
-- Defined-By: systemd
-- Support: https://access.redhat.com/support
--
-- Automatic restarting of the unit mysqld.service has been scheduled, as the result for
-- the configured Restart= setting for the unit.
Sep 16 02:58:58 FirsthandPersonal-VM systemd[1]: Stopped MySQL 8.0 database server.
-- Subject: Unit mysqld.service has finished shutting down
-- Defined-By: systemd
-- Support: https://access.redhat.com/support
--
-- Unit mysqld.service has finished shutting down.
Sep 16 02:58:58 FirsthandPersonal-VM systemd[1]: Starting MySQL 8.0 database server...
-- Subject: Unit mysqld.service has begun start-up
-- Defined-By: systemd
-- Support: https://access.redhat.com/support
--
-- Unit mysqld.service has begun starting up.
查看var/log/mysql/mysql.log日志文件是空的
运行mysqld,可以看到报错
编辑mysql配置文件,添加user=root,后期再观察
发表评论