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

最新推荐文章于 2023-12-20 10:42:16 发布

原创最新推荐文章于 2023-12-20 10:42:16 发布 · 1.4w 阅读

1 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

6 篇文章

订阅专栏

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

启动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

启动成功