VM虚拟机CentOS7下mysql服务启动失败的解决办法

最新推荐文章于 2022-08-12 14:49:44 发布
最新推荐文章于 2022-08-12 14:49:44 发布
阅读量5.3k 收藏 9
点赞数 3
分类专栏： Linux笔记
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_40143313/article/details/78737842
版权

1.启动mysql服务

[root@localhost ~]# service mysqld start

报错：

Starting mysqld (via systemctl):  Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
[失败]
查看mysql服务的启动日志：

[root@localhost ~]# cat /var/log/mysqld.log
2017-12-07T01:13:17.421614Z 0 [ERROR] /usr/sbin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2 - No such file or directory)
2017-12-07T01:13:17.421651Z 0 [ERROR] Can't start server: can't create PID file: No such file or directory.
 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended


发现mysql服务启动的时候不能创建PID文件。 

 

在终端查看发现果然没有/var/run/mysqld这个文件，所以创建一个：

[root@localhost ~]# mkdir -p /var/run/mysqld

 

然后再重启mysql的服务，可是还是失败：

 

[root@localhost ~]# /etc/init.d/mysqld start
Starting mysqld (via systemctl):  Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
[失败]

发现/var/run/mysqld/的属主和属组还是root，mysql并不能在其中创建文件，后修改该目录的属主和属组，启动成功。

 

[root@localhost ~]# ls -ld /var/run/mysqld/
drwxr-xr-x. 2 root root 40 12月  7 09:53 /var/run/mysqld/
[root@localhost ~]# chown mysql.mysql /var/run/mysqld/
[root@localhost ~]# /etc/init.d/mysqld start
Starting mysqld (via systemctl):  [  确定  ]

 

重启虚拟机之后打开Ambari页面要开启的服务

 

首先开启Mysql：

[root@master ~]# mkdir -p /var/run/mysqld
[root@master ~]# chown mysql.mysql /var/run/mysqld/
[root@master ~]# service mysqld start
Starting mysqld (via systemctl):  [  OK  ]


之后就是http服务：

[root@master ~]# service httpd start
Redirecting to /bin/systemctl start  httpd.service


检查配置完整性：

[root@master ~]# yum clean all
Loaded plugins: fastestmirror, langpacks
Cleaning repos: HDP-2.4 HDP-UTILS-1.1.0.20 Updates-ambari-2.2.1.1 base extras updates
Cleaning up everything
Cleaning up list of fastest mirrors

 

[root@master ~]# yum repolist
Loaded plugins: fastestmirror, langpacks
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP/centos7/2.x/updates/2.4.0.0/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP-UTILS-1.1.0.20/repos/centos7/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP-UTILS-1.1.0.20/repos/centos7/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP-UTILS-1.1.0.20/repos/centos7/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP-UTILS-1.1.0.20/repos/centos7/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP-UTILS-1.1.0.20/repos/centos7/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP-UTILS-1.1.0.20/repos/centos7/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP-UTILS-1.1.0.20/repos/centos7/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP-UTILS-1.1.0.20/repos/centos7/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP-UTILS-1.1.0.20/repos/centos7/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/HDP-UTILS-1.1.0.20/repos/centos7/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/AMBARI-2.2.1.1/centos7/2.2.1.1-70/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/AMBARI-2.2.1.1/centos7/2.2.1.1-70/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/AMBARI-2.2.1.1/centos7/2.2.1.1-70/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/AMBARI-2.2.1.1/centos7/2.2.1.1-70/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/AMBARI-2.2.1.1/centos7/2.2.1.1-70/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/AMBARI-2.2.1.1/centos7/2.2.1.1-70/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/AMBARI-2.2.1.1/centos7/2.2.1.1-70/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/AMBARI-2.2.1.1/centos7/2.2.1.1-70/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/AMBARI-2.2.1.1/centos7/2.2.1.1-70/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
http://192.168.24.131/AMBARI-2.2.1.1/centos7/2.2.1.1-70/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to 192.168.24.131:80; Connection refused"
Trying other mirror.
base/7/x86_64                                                                                                                                                                 | 3.6 kB  00:00:00     
base/7/x86_64/group_gz                                                                                                                                                        | 156 kB  00:00:00     
base/7/x86_64/primary_db                                                                                                                                                      | 5.7 MB  00:00:00     
extras/7/x86_64                                                                                                                                                               | 3.4 kB  00:00:00     
extras/7/x86_64/primary_db                                                                                                                                                    | 145 kB  00:00:00     
updates/7/x86_64                                                                                                                                                              | 3.4 kB  00:00:00     
updates/7/x86_64/primary_db                                                                                                                                                   | 4.5 MB  00:00:00     
repo id                                                                                       repo name                                                                                        status
HDP-2.4                                                                                       HDP-2.4                                                                                              0
HDP-UTILS-1.1.0.20                                                                            HDP-UTILS-1.1.0.20                                                                                   0
Updates-ambari-2.2.1.1                                                                        ambari-2.2.1.1 - Updates                                                                             0
base/7/x86_64                                                                                 CentOS-7 - Base                                                                                  9,591
extras/7/x86_64                                                                               CentOS-7 - Extras                                                                                  327
updates/7/x86_64                                                                              CentOS-7 - Updates                                                                               1,540
repolist: 11,458


最后开启ambari服务：

[root@master ~]# ambari-server start
Using python  /usr/bin/python
Starting ambari-server
Ambari Server running with administrator privileges.
Organizing resource files at /var/lib/ambari-server/resources...
Server PID at: /var/run/ambari-server/ambari-server.pid
Server out at: /var/log/ambari-server/ambari-server.out
Server log at: /var/log/ambari-server/ambari-server.log
Waiting for server start....................
Ambari Server 'start' completed successfully.

 

 

 


 

 

Floyle
关注
  • 3
    点赞
  • 踩
  • 9
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
mysql 启动失败 Pid无法创建
dd_8023dd的博客
08-08 887
MySQL 启动报错信息如下： Starting mysqld (via systemctl): Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for detail...
Job for mysqld.service failed because the control process exited with error code. See “systemctl sta
qq_42093887的博客
07-26 3091
Mysql服务启动失败可尝试一下方法解决 [root@localhost zyjh6666]# mkdir -p /var/run/mysqld/ [root@localhost zyjh6666]# [root@localhost zyjh6666]#/etc/init.d/m...
CentOS 7下MySQL服务启动失败的快速解决方法
09-10
CentOS 7下MySQL服务启动失败怎么办？下面小编就为大家带来一篇CentOS 7下MySQL服务启动失败的快速解决方法。现在分享给大家，也给大家做个参考。一起跟随小编过来看看吧
MySQL启动报错Job for mysqld.service failed because the
flyingspark的博客
08-12 1836
百度好久没发现个所以然，特此记录一下，不用按照报错提示来启动或者执行"systemctl status mysqld.service" and "journalctl -xe"这个太扯淡，一般自己维护的服务自己能不知道启动命令吗？直接看MySQL启动日志就行，直接最后一行向上找，找到最近的一个error，百分之99都是因为你my.cof配置文件中有错误的配置了，修改一下就行。启动不成功无非就是启动命令、服务器资源环境、my.cnf的配置文件问题。修改my.cnf文件中相关值即可。以下是我自己报错的截图。..
CentOS7--MySQL无法启动解决办法
nice_muyu的博客
05-04 7111
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
MySQL 自启动时报错can't create PID file: No such file or directory
GoodIdea
01-14 870
系统版本：Red Hat Enterprise Linux Server release 7.0  MySQL版本：5.7.16-1.el6.x86_64  安装MySQL后，设置好了开机自启动。  但是重启服务器后，MySQL并没有启动，查看日志如下： 2018-04-13T06:27:24.608793Z 0 [ERROR] /usr/sbin/mysqld: Can’t create/wr...
CentOS7下MySQL8的主主互备安装文档和my.cnf配置文件
12-17
本教程将深入探讨如何在CentOS7操作系统环境下，利用VM虚拟机安装MySQL8.0.13，并实现主主互备的高可用性配置。这有助于确保数据的冗余和连续性，降低单点故障的风险。 首先，我们从【标题】入手，"CentOS7下MySQL8...
VM虚拟机CentOS安装图解、开发环境搭建
10-09
VM虚拟机CentOS安装图解、开发环境搭建 本文档主要说明以下几部分： 1、VMware上CentOs的安装 2、MySql的启动以及操作 3、Oracle的安装及操作 4、tomcat服务器的架设及操作 5、项目部署及数据的导入
Windows下Pycharm远程连接虚拟机中Centos下的Python环境(图文教程详解)
12-20
为了方便程序的调试，尝试在Windows下的Pycharm远程连接到虚拟机中Centos下的Python环境。（这里我采用的是ssh的远程连接） 1、准备工作： 固定centos的IP，这里我的固定IP为 192.168.254.128 。 centos中安装ssh...
mysql-5.7.27-1.el7.x86_64.rpm-bundle
11-29
总的来说，这个压缩包提供了一个完整的MySQL部署解决方案，包括服务器和客户端，适合在VM虚拟机上进行安装和测试。如果你不熟悉这个过程，可以参考提供的博客教程，以确保正确安装和配置MySQL。记住，安全性和稳定性...
vagrant-latmp：Vagrant LA（T）MP堆栈：CentOS 7 + Apache HTTP + Apache Tomcat + MySQL + PHP + Python + Ruby + Node.js
02-06
**Linux (CentOS 7)**：作为基础操作系统，CentOS 7是一个稳定且广泛使用的Linux发行版，适合服务器部署。它提供了强大的软件包管理和更新机制，便于安装和维护各种服务。 **Apache HTTP Server**：Apache是世界上...
MySQL5.7重启MySQL服务时报错解决方案
bpb_cx的博客
11-06 3943
一、启动mysql的服务时报错；使用了提示的两种方法并没有提供可靠解决的信息 [root@localhost data]# systemctl restart mysqld.service Starting mysqld (via systemctl): Job for mysqld.service failed because the control process exited with...
启动mysql报错Job for mysqld.service failed because the control process exited with error code.
热门推荐
lichao1618的博客
06-25 2万+
启动mysql报错Job for mysqld.service failed because the control process exited with error code.
linux mysql 安装启动失败_linux安装mysql启动不起来总结
weixin_39566578的博客
02-26 779
今天，启动MySQL服务器失败，如下所示：[root@spark01 ~]# /etc/init.d/mysqld startStarting mysqld (via systemctl): Job for mysqld.service failed because the control process exited with error code. See "systemctl status...
centeros 7 启动mysql失败_CentOS 7下MySQL服务启动失败的解决思路
weixin_42300960的博客
01-19 498
今天兴趣来袭，装了CentOS7，安装了mysql5.7；启动MySQL服务器失败，如下所示：[root@spark01 ~]# /etc/init.d/mysqld startStarting mysqld (via systemctl): Job for mysqld.service failed because the control process exited with error c...
史上最详细Centos7安装MySQL5.7教程
qq_33996921的博客
03-15 4463
为了方便记录一下MySQL的安装过程，特意写此文进行记录； 1、安装环境 [root@VM_0_9_centos ~]# lsb_release -a LSB Version: :core-4.1-amd64:core-4.1-noarch:cxx-4.1-amd64:cxx-4.1-noarch:desktop-4.1-amd64:desktop-4.1-noarch:languages-4.1...
etc init.d下没有mysql文件_安装mysql 开启服务时出错/etc/init.d/mysqld: line 264: 的解决办法...
weixin_29614359的博客
02-01 1106
https://blog.51cto.com/genxin/1783419basedir 设置正确后，又出现，错误[root@localhost ~]# service mysqld startStarting MySQL.Logging to ‘/usr/local/mysql-5.5.60/localhost.localdomain.err‘.190608 21:24:11 mysqld_sa...
启动MYSQL 服务失败：Redirecting to /bin/systemctl status mysql.service
Gentry_Lunatic的博客
05-24 8494
在kylin_v10系统下，学习mysql数据库时。系统默认装了数据库。想要直接使用。在启动时报以下错误。 [root@localhost bin]# service mysql statusRedirecting to /bin/systemctl status mysql.service Unit mysql.service could not be found. [root@localhost bin]# systemctl start mysqldFailed to start mysqld.s
Mysql启动失败，报Can‘t start server: can‘t create PID file: No such file or directory解决方案
康师傅没有眼泪
08-26 1660
Mysql启动失败，报Can't start server: can't create PID file: No such file or directory解决方案 一、原因分析 MySQL 数据存放位置改为 数据盘地址，重启机器，然后磁盘挂载没有设置为开机自动挂载，导致PID 文件找不到。 二、问题定位 查看日志，/var/log/mysql 查看原因 三、 解决方法 1. 在/etc/my.cnf中查看pid-file的位置 pid-file=/var/run/m...
vm虚拟机centos7无法上网
最新发布
10-17
可能是网络配置问题导致的。您可以尝试以下步骤来解决这个问题： 1. 检查虚拟机的网络设置是否正确，确保虚拟机的网络适配器已经连接到正确的网络。 2. 检查虚拟机的 IP 地址是否正确，可以通过在虚拟机中运行 `ifconfig` 命令来查看。 3. 检查虚拟机的 DNS 配置是否正确，可以通过在虚拟机中运行 `cat /etc/resolv.conf` 命令来查看。 4. 如果您使用的是 NAT 网络模式，尝试在虚拟机中运行 `sudo dhclient` 命令来获取 IP 地址和 DNS 配置。 5. 如果您使用的是桥接网络模式，确保主机和虚拟机在同一局域网内，并且主机上的防火墙没有阻止虚拟机的网络连接。 6. 如果您使用的是 Host-Only 网络模式，确保主机和虚拟机都已经启用了 Host-Only 网络适配器，并且它们都在同一个子网内。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值