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

一、问题

MySQL启动时提示如下错误:

[ck@hadoop102 conf]$ sudo systemctl start mysqld.service
[sudo] atguigu 的密码:
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.

二、原因分析

查看日志分析

[root@hadoop102 conf]# journalctl -xe
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysqld.service has failed.
-- 
-- The result is failed.
2月 08 09:50:30 hadoop102 systemd[1]: Unit mysqld.service entered failed state.
2月 08 09:50:30 hadoop102 systemd[1]: mysqld.service failed.
2月 08 09:50:31 hadoop102 setroubleshoot[5663]: SELinux is preventing /usr/sbin/mysqld from write access on the file ibdata1. For comple
2月 08 09:50:31 hadoop102 python[5663]: SELinux is preventing /usr/sbin/mysqld from write access on the file ibdata1.
                                         
                                         *****  Plugin catchall_labels (83.8 confidence) suggests   *******************
                                         
                                         If you want to allow mysqld to have write access on the ibdata1 file
                                         Then you need to change the label on ibdata1
                                         Do
                                         # semanage fcontext -a -t FILE_TYPE ibdata1
                                         where FILE_TYPE is one of the following: afs_cache_t, faillog_t, hugetlbfs_t, initrc_tmp_t, krb
                                         Then execute:
                                         restorecon -v ibdata1
                                         
                                         
                                         *****  Plugin catchall (17.1 confidence) suggests   **************************
                                         
                                         If you believe that mysqld should be allowed write access on the ibdata1 file by default.
                                         Then you should report this as a bug.
                                         You can generate a local policy module to allow this access.
                                         Do
                                         allow this access for now by executing:
                                         # ausearch -c mysqld --raw | audit2allow -M my-mysqld
                                         # semodule -i my-mysqld.pp
                                         
2月 08 09:50:31 hadoop102 systemd[1]: mysqld.service holdoff time over, scheduling restart.
2月 08 09:50:31 hadoop102 systemd[1]: Stopped MySQL Server.
-- Subject: Unit mysqld.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysqld.service has finished shutting down.
2月 08 09:50:31 hadoop102 systemd[1]: Starting MySQL Server...
-- Subject: Unit mysqld.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysqld.service has begun starting up.

selinux限制导致mysql服务启动失败

三、解决办法

[root@hadoop102 conf]# getenforce     (查看selinux状态)
Enforcing
[root@hadoop102 conf]# setenforce 0    (临时关闭)
[root@hadoop102 conf]# vim /etc/selinux/config     (永久关闭,将SELINUX=enforcing改为SELINUX=disabled,保存后退出)  
[root@hadoop102 conf]# getenforce              
Permissive
[root@hadoop102 conf]# systemctl start mysqld.service
[root@hadoop102 conf]# systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since 一 2021-02-08 10:02:40 CST; 42s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 6370 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
  Process: 6346 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 6372 (mysqld)
    Tasks: 27
   CGroup: /system.slice/mysqld.service
           └─6372 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

2月 08 10:02:39 hadoop102 mysqld[6370]: 2021-02-08T02:02:39.259391Z 0 [Note] Skipping generation of SSL certificates as ce...ectory.
2月 08 10:02:39 hadoop102 mysqld[6370]: 2021-02-08T02:02:39.283310Z 0 [Warning] CA certificate ca.pem is self signed.
2月 08 10:02:39 hadoop102 mysqld[6370]: 2021-02-08T02:02:39.283368Z 0 [Note] Skipping generation of RSA key pair as key fi...ectory.
2月 08 10:02:39 hadoop102 mysqld[6370]: 2021-02-08T02:02:39.340104Z 0 [Note] Server hostname (bind-address): *; port: 3306
2月 08 10:02:39 hadoop102 mysqld[6370]: 2021-02-08T02:02:39.396911Z 0 [Note] IPv6 is available.
2月 08 10:02:39 hadoop102 mysqld[6370]: 2021-02-08T02:02:39.396987Z 0 [Note]   - :: resolves to ::;
2月 08 10:02:39 hadoop102 mysqld[6370]: 2021-02-08T02:02:39.397056Z 0 [Note] Server socket created on IP: ::.
2月 08 10:02:39 hadoop102 mysqld[6370]: 2021-02-08T02:02:39.399136Z 0 [Note] InnoDB: Buffer pool(s) load completed at 2102...0:02:39
2月 08 10:02:40 hadoop102 mysqld[6370]: 2021-02-08T02:02:40.123553Z 0 [Note]
2月 08 10:02:40 hadoop102 systemd[1]: Started MySQL Server.
Hint: Some lines were ellipsized, use -l to show in full.
[root@hadoop102 conf]# 

 

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

上一篇:Jmeter导入badboy的jmx文件后,使用后置处理器的正则表达式提取器提取URL论坛板块ID失败


下一篇:MySQL CONCAT函数:字符串拼接