启动mysql报错:mysql.service: Service hold-off time over, scheduling restart.

本文记录了一次MySQL启动过程中遇到的问题及解决方案。启动时出现了错误提示,并通过执行特定的chown命令来更改目录所有者为mysql:mysql,最终使得MySQL能够正常启动。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

启动mysql时报错

root@iZ2ze58mrrj1x9veg257uvZ conf.d]# systemctl status mysqld.service
● mysqld.service - MySQL Community Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: activating (start-post) since Mon 2018-07-02 02:08:22 CST; 1min 39s ago
  Process: 18855 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
  Process: 18540 ExecStartPre=/usr/bin/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 18855 (code=exited, status=0/SUCCESS);         : 18856 (mysql-systemd-s)
   Memory: 17.4M
   CGroup: /system.slice/mysqld.service
           └─control
             ├─ 3514 sleep 1
             └─18856 /bin/bash /usr/bin/mysql-systemd-start post

Jul 02 02:08:22 iZ2ze58mrrj1x9veg257uvZ systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 02 02:08:22 iZ2ze58mrrj1x9veg257uvZ systemd[1]: Starting MySQL Community Server...
Jul 02 02:08:25 iZ2ze58mrrj1x9veg257uvZ mysqld_safe[18855]: 180702 02:08:25 mysqld_safe Logging to '/var/log/mysqld.log'.
Jul 02 02:08:25 iZ2ze58mrrj1x9veg257uvZ mysqld_safe[18855]: 180702 02:08:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

执行 chown mysql:mysql -R /var/lib/mysql


启动成功



-- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: 2025-06-19 16:01:55 0 [Note] / usr/sbin/mysqld (mysqld 5.6.51) starting as process 12930 ... 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: 2025-06-19 16:01:55 12930 [Not e] /usr/sbin/mysqld: Shutdown complete 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: 2025-06-19 16:01:55 0 [Note] / usr/sbin/mysqld (mysqld 5.6.51) starting as process 12941 ... 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: 2025-06-19 16:01:55 12941 [Not e] /usr/sbin/mysqld: Shutdown complete 6月 19 16:01:55 localhost.localdomain mysql-systemd-start[12907]: --defaults-file argument to my sqld_safe when starting the server 6月 19 16:01:56 localhost.localdomain mysqld_safe[12953]: 250619 16:01:56 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 16:01:56 localhost.localdomain mysqld_safe[12953]: 250619 16:01:56 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 16:01:56 localhost.localdomain mysqld_safe[12953]: 250619 16:01:56 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 16:11:55 localhost.localdomain systemd[1]: mysqld.service start-post operation timed out. Stopping. -- Subject: Unit mysqld.service has failed -- Unit mysqld.service has failed. 6月 19 16:11:55 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state. 6月 19 16:11:55 localhost.localdomain systemd[1]: mysqld.service failed. 6月 19 16:11:56 localhost.localdomain systemd[1]: mysqld.service holdoff time over, scheduling r estart. -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 16:11:56 localhost.localdomain mysqld_safe[19213]: 250619 16:11:56 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 16:11:56 localhost.localdomain mysqld_safe[19213]: 250619 16:11:56 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 16:11:57 localhost.localdomain mysqld_safe[19213]: 250619 16:11:57 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 16:23:58 localhost.localdomain mysql-systemd-start[27149]: 2025-06-19 16:23:58 0 [Note] / usr/sbin/mysqld (mysqld 5.6.51) starting as process 27165 ... 6月 19 16:24:00 localhost.localdomain mysql-systemd-start[27149]: 2025-06-19 16:24:00 0 [Note] / usr/sbin/mysqld (mysqld 5.6.51) starting as process 27201 ... 6月 19 16:24:02 localhost.localdomain mysql-systemd-start[27149]: --defaults-file argument to my sqld_safe when starting the server 6月 19 16:24:03 localhost.localdomain mysqld_safe[27239]: 250619 16:24:03 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 16:24:03 localhost.localdomain mysqld_safe[27239]: 250619 16:24:03 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql -- Subject: Unit mysqld.service has finished start-up -- Unit mysqld.service has finished starting up. -- Subject: Unit mysqld.service has begun shutting down -- Unit mysqld.service has begun shutting down. 6月 19 16:42:34 localhost.localdomain mysqld_safe[27239]: 250619 16:42:34 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 16:42:35 localhost.localdomain mysqld_safe[35199]: 250619 16:42:35 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 16:42:35 localhost.localdomain mysqld_safe[35199]: 250619 16:42:35 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql -- Subject: Unit mysqld.service has finished start-up -- Unit mysqld.service has finished starting up. 6月 19 17:22:37 localhost.localdomain sudo[52110]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl restart mysqld -- Subject: Unit mysqld.service has begun shutting down -- Unit mysqld.service has begun shutting down. 6月 19 17:22:38 localhost.localdomain mysqld_safe[35199]: 250619 17:22:38 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:22:39 localhost.localdomain mysqld_safe[52143]: 250619 17:22:39 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:22:39 localhost.localdomain mysqld_safe[52143]: 250619 17:22:39 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:22:41 localhost.localdomain mysqld_safe[52143]: 250619 17:22:41 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 17:23:26 localhost.localdomain sudo[52851]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl restart mysqld -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:23:26 localhost.localdomain mysqld_safe[52874]: 250619 17:23:26 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:23:26 localhost.localdomain mysqld_safe[52874]: 250619 17:23:26 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:23:28 localhost.localdomain mysqld_safe[52874]: 250619 17:23:28 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:24:11 localhost.localdomain mysqld_safe[53592]: 250619 17:24:11 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:24:11 localhost.localdomain mysqld_safe[53592]: 250619 17:24:11 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:24:14 localhost.localdomain mysqld_safe[53592]: 250619 17:24:14 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 17:25:12 localhost.localdomain systemd[1]: mysqld.service: control process exited, code=k illed status=9 -- Subject: Unit mysqld.service has failed -- Unit mysqld.service has failed. 6月 19 17:25:12 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state. 6月 19 17:25:12 localhost.localdomain systemd[1]: mysqld.service failed. 6月 19 17:25:12 localhost.localdomain systemd[1]: mysqld.service holdoff time over, scheduling r estart. -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:25:13 localhost.localdomain mysqld_safe[54465]: 250619 17:25:13 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:25:13 localhost.localdomain mysqld_safe[54465]: 250619 17:25:13 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:25:15 localhost.localdomain mysqld_safe[54465]: 250619 17:25:15 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 17:25:34 localhost.localdomain sudo[54929]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl restart mysqld -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:25:34 localhost.localdomain mysqld_safe[54953]: 250619 17:25:34 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:25:34 localhost.localdomain mysqld_safe[54953]: 250619 17:25:34 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:25:36 localhost.localdomain mysqld_safe[54953]: 250619 17:25:36 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended 6月 19 17:26:42 localhost.localdomain sudo[55901]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/pkill -9 mysqld 6月 19 17:26:49 localhost.localdomain sudo[55973]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/mysqld_safe --defaults-file=/etc/my.cnf 6月 19 17:31:13 localhost.localdomain sudo[58906]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl status mysqld 6月 19 17:33:49 localhost.localdomain sudo[60461]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl status mysqld 6月 19 17:33:59 localhost.localdomain sudo[60563]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/sbin/service mysqld status 6月 19 17:34:08 localhost.localdomain sudo[60663]: root : TTY=pts/1 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl start mysqld 6月 19 17:34:32 localhost.localdomain sudo[60935]: root : TTY=pts/0 ; PWD=/root ; USER=root ; COMMAND=/bin/systemctl start mysqld 6月 19 17:34:50 localhost.localdomain sudo[61150]: root : TTY=pts/0 ; PWD=/root ; USER=root ; COMMAND=/sbin/service mysqld status 6月 19 17:35:34 localhost.localdomain systemd[1]: mysqld.service start-post operation timed out. Stopping. -- Subject: Unit mysqld.service has failed -- Unit mysqld.service has failed. 6月 19 17:35:34 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state. 6月 19 17:35:34 localhost.localdomain systemd[1]: mysqld.service failed. 6月 19 17:35:34 localhost.localdomain systemd[1]: mysqld.service holdoff time over, scheduling r estart. -- Subject: Unit mysqld.service has finished shutting down -- Unit mysqld.service has finished shutting down. -- Subject: Unit mysqld.service has begun start-up -- Unit mysqld.service has begun starting up. 6月 19 17:35:35 localhost.localdomain mysqld_safe[61625]: 250619 17:35:35 mysqld_safe Logging to '/var/log/mysqld.log'. 6月 19 17:35:35 localhost.localdomain mysqld_safe[61625]: 250619 17:35:35 mysqld_safe Starting m ysqld daemon with databases from /var/lib/mysql 6月 19 17:35:37 localhost.localdomain mysqld_safe[61625]: 250619 17:35:37 mysqld_safe mysqld fro m pid file /var/run/mysqld/mysqld.pid ended
06-20
[admin@localhost zabbix]$ sudo pkill -9 zabbix_server [admin@localhost zabbix]$ sudo ipcs -m | grep zabbix | awk '{print $2}' | xargs -I{} sudo ipcrm -m {} # 清理共享内存 [admin@localhost zabbix]$ sudo systemctl daemon-reload [admin@localhost zabbix]$ sudo systemctl start zabbix-server [admin@localhost zabbix]$ sudo journalctl -u zabbix-server -f --since "2 minutes ago" -- Logs begin at 四 2025-06-12 16:09:34 CST. -- 6月 15 13:04:58 localhost.localdomain systemd[1]: Stopped Zabbix Server. 6月 15 13:04:58 localhost.localdomain systemd[1]: Unit zabbix-server.service entered failed state. 6月 15 13:04:58 localhost.localdomain systemd[1]: zabbix-server.service failed. 6月 15 13:04:58 localhost.localdomain systemd[1]: Starting Zabbix Server... 6月 15 13:04:58 localhost.localdomain systemd[1]: zabbix-server.service: Supervising process 55999 which is not our child. We'll most likely not notice when it exits. 6月 15 13:04:58 localhost.localdomain systemd[1]: Started Zabbix Server. 6月 15 13:05:00 localhost.localdomain kill[56057]: 用法: 6月 15 13:05:00 localhost.localdomain kill[56057]: kill [选项] <pid|名称> [...] 6月 15 13:05:00 localhost.localdomain kill[56057]: 选项: 6月 15 13:05:00 localhost.localdomain kill[56057]: -a, --all 不限于只对和当前进程的用户 id 相同的进程进行 6月 15 13:05:00 localhost.localdomain kill[56057]: 名称-进程id 转换 6月 15 13:05:00 localhost.localdomain kill[56057]: -s, --signal <信号> 发送指定的信号 6月 15 13:05:00 localhost.localdomain kill[56057]: -q, --queue <信号> 使用 sigqueue(2) 代替 kill(2) 6月 15 13:05:00 localhost.localdomain kill[56057]: -p, --pid 打印 pid 而不向它们发送信号 6月 15 13:05:00 localhost.localdomain kill[56057]: -l, --list [=<信号>] 列出信号名,或将一个信号转换为名称 6月 15 13:05:00 localhost.localdomain kill[56057]: -L, --table 列出信号名和数值 6月 15 13:05:00 localhost.localdomain kill[56057]: -h, --help 显示此帮助并退出 6月 15 13:05:00 localhost.localdomain kill[56057]: -V, --version 输出版本信息并退出 6月 15 13:05:00 localhost.localdomain kill[56057]: 更多信息请参阅 kill(1)。 6月 15 13:05:00 localhost.localdomain systemd[1]: zabbix-server.service: control process exited, code=exited status=1 6月 15 13:05:00 localhost.localdomain systemd[1]: Unit zabbix-server.service entered failed state. 6月 15 13:05:00 localhost.localdomain systemd[1]: zabbix-server.service failed. 6月 15 13:05:17 localhost.localdomain systemd[1]: zabbix-server.service holdoff time over, scheduling restart. 6月 15 13:05:17 localhost.localdomain systemd[1]: Stopped Zabbix Server. 6月 15 13:05:17 localhost.localdomain systemd[1]: Starting Zabbix Server... 6月 15 13:05:17 localhost.localdomain systemd[1]: Started Zabbix Server. 6月 15 13:05:19 localhost.localdomain kill[56180]: 用法: 6月 15 13:05:19 localhost.localdomain systemd[1]: zabbix-server.service: control process exited, code=exited status=1 6月 15 13:05:19 localhost.localdomain kill[56180]: kill [选项] <pid|名称> [...] 6月 15 13:05:19 localhost.localdomain kill[56180]: 选项: 6月 15 13:05:19 localhost.localdomain kill[56180]: -a, --all 不限于只对和当前进程的用户 id 相同的进程进行 6月 15 13:05:19 localhost.localdomain kill[56180]: 名称-进程id 转换 6月 15 13:05:19 localhost.localdomain kill[56180]: -s, --signal <信号> 发送指定的信号 6月 15 13:05:19 localhost.localdomain kill[56180]: -q, --queue <信号> 使用 sigqueue(2) 代替 kill(2) 6月 15 13:05:19 localhost.localdomain kill[56180]: -p, --pid 打印 pid 而不向它们发送信号 6月 15 13:05:19 localhost.localdomain kill[56180]: -l, --list [=<信号>] 列出信号名,或将一个信号转换为名称 6月 15 13:05:19 localhost.localdomain kill[56180]: -L, --table 列出信号名和数值 6月 15 13:05:19 localhost.localdomain kill[56180]: -h, --help 显示此帮助并退出 6月 15 13:05:19 localhost.localdomain kill[56180]: -V, --version 输出版本信息并退出 6月 15 13:05:19 localhost.localdomain kill[56180]: 更多信息请参阅 kill(1)。 6月 15 13:05:19 localhost.localdomain systemd[1]: Unit zabbix-server.service entered failed state. 6月 15 13:05:19 localhost.localdomain systemd[1]: zabbix-server.service failed. ^C [admin@localhost zabbix]$ ^C
06-16
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值