启动mysql报错：Job for mysqld.service failed because the control process exited with error code.See “sys

最新推荐文章于 2024-12-07 22:53:00 发布

原创

最新推荐文章于 2024-12-07 22:53:00 发布 · 1.9w 阅读

14 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #linux

在CentOS8环境下安装MySQL时遇到启动失败的问题，报错信息为Job for mysqld.service failed due to a permission issue. 查看systemctl status mysqld.service显示Error 13 (Permission denied)。原因是首次启动MySQL服务时，由于缺少权限未能创建'/var/lib/mysql/auto.cnf'文件，导致服务初始化失败。解决方法是使用root用户并加上sudo执行授权命令，使MySQL服务能够正常启动。

环境：centOS8

按照 MySQL 安装教程操作，到下面这步出现报错：

# systemctl start mysqld
Job for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xe" for details.

1.根据提示用 systemctl status mysqld.service 看了下

# systemctl status mysqld.service
● mysqld.service - MySQL 8.0 database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Thu 2022-02-24 16:45:08 CST; 50s ago
  Process: 64678 ExecStopPost=/usr/libexec/mysql-wait-stop (code=exited, status=0/SUCCESS)
  Process: 64676 ExecStart=/usr/libexec/mysqld --basedir=/usr (code=exited, status=1/FAILURE)
  Process: 64639 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mysqld.service