mysql启动报错Fatal error: Please read "Security" section of the manual to find out how to run mysqld as

 admin   2022-09-16 15:38   149 人阅读  0 条评论

Mysql报错,我是视频采集,可能是占用过高,但是重启失败了

图片.png

执行:

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.

图片.png

查看var/log/mysql/mysql.log日志文件是空的

图片.png

运行mysqld,可以看到报错

图片.png

编辑mysql配置文件,添加user=root,后期再观察

图片.png

本文地址:https://liuchunjie.top/?id=487
版权声明:本文为原创文章,版权归 admin 所有,欢迎分享本文,转载请保留出处!

 发表评论


表情

还没有留言,还不快点抢沙发?