AsiaDIT 2022-01-28 09:42 采纳率: 42.9%
浏览 121
已结题

mysqld 启动报错 找了很多博客文章依然无法解决

######Alibaba Cloud Linux 2.1903 LTS 64位
安装步骤如下:
systemctl stop firewalld
SELinux状态参数是Disabled
rpm -Uvh http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
yum -y install mysql-community-server
mysql -V
mysql Ver 14.14 Distrib 5.7.36, for Linux (x86_64) using EditLine wrapper
systemctl start mysqld 开始报错调试了很久没办法

systemctl start mysqld 启动报错 日志如下
[root@admin-manager /]# 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.
[root@admin-manager /]# systemctl status mysqld.service
鈼?[0m mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: failed (Result: start-limit) since Fri 2022-01-28 01:53:13 CST; 7s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 22668 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
  Process: 22651 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

Jan 28 01:53:13 admin-manager systemd[1]: Failed to start MySQL Server.
Jan 28 01:53:13 admin-manager systemd[1]: Unit mysqld.service entered failed state.
Jan 28 01:53:13 admin-manager systemd[1]: mysqld.service failed.
Jan 28 01:53:13 admin-manager systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jan 28 01:53:13 admin-manager systemd[1]: Stopped MySQL Server.
Jan 28 01:53:13 admin-manager systemd[1]: start request repeated too quickly for mysqld.service
Jan 28 01:53:13 admin-manager systemd[1]: Failed to start MySQL Server.
Jan 28 01:53:13 admin-manager systemd[1]: Unit mysqld.service entered failed state.
Jan 28 01:53:13 admin-manager systemd[1]: mysqld.service failed.
[root@admin-manager /]# journalctl -xe
-- Unit mysqld.service has finished shutting down.
Jan 28 01:53:12 admin-manager 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.
Jan 28 01:53:12 admin-manager mysqld[22644]: Initialization of mysqld failed: 0
Jan 28 01:53:12 admin-manager systemd[1]: mysqld.service: control process exited, code=exited status=1
Jan 28 01:53:12 admin-manager systemd[1]: Failed to start MySQL Server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysqld.service has failed.
-- 
-- The result is failed.
Jan 28 01:53:12 admin-manager systemd[1]: Unit mysqld.service entered failed state.
Jan 28 01:53:12 admin-manager systemd[1]: mysqld.service failed.
Jan 28 01:53:12 admin-manager systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jan 28 01:53:12 admin-manager 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.
Jan 28 01:53:12 admin-manager 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.
Jan 28 01:53:13 admin-manager mysqld[22668]: Initialization of mysqld failed: 0
Jan 28 01:53:13 admin-manager systemd[1]: mysqld.service: control process exited, code=exited status=1
Jan 28 01:53:13 admin-manager systemd[1]: Failed to start MySQL Server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysqld.service has failed.
-- 
-- The result is failed.
Jan 28 01:53:13 admin-manager systemd[1]: Unit mysqld.service entered failed state.
Jan 28 01:53:13 admin-manager systemd[1]: mysqld.service failed.
Jan 28 01:53:13 admin-manager systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jan 28 01:53:13 admin-manager 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.
Jan 28 01:53:13 admin-manager systemd[1]: start request repeated too quickly for mysqld.service
Jan 28 01:53:13 admin-manager systemd[1]: Failed to start MySQL Server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysqld.service has failed.
-- 
-- The result is failed.
Jan 28 01:53:13 admin-manager systemd[1]: Unit mysqld.service entered failed state.

我想要达到的结果
  • 写回答

8条回答 默认 最新

  • IT民工金鱼哥 运维领域新星创作者 2022-01-28 10:01
    关注

    看具体报错日志,看这里的不是详细日志。
    看/var/log 下面的日志。甚至去看messages日志都会有提示噶

    评论

报告相同问题?

问题事件

  • 已结题 (查看结题原因) 2月3日
  • 创建了问题 1月28日

悬赏问题

  • ¥15 为什么eclipse不能再下载了?
  • ¥15 编辑cmake lists 明明写了project项目名,但是还是报错怎么回事
  • ¥15 关于#计算机视觉#的问题:求一份高质量桥梁多病害数据集
  • ¥15 特定网页无法访问,已排除网页问题
  • ¥50 如何将脑的图像投影到颅骨上
  • ¥15 提问一个关于vscode相关的环境配置问题,就是输入中文但是显示不出来,代码在idea可以显示中文,但在vscode不行,不知道怎么配置环境
  • ¥15 netcore使用PuppeteerSharp截图
  • ¥20 这张图页头,页脚具体代码该怎么写?
  • ¥20 WPF MVVM模式 handycontrol 框架, hc:SearchBar 控件 Text="{Binding NavMenusKeyWords}" 绑定取不到值
  • ¥15 需要手写数字信号处理Dsp三个简单题 不用太复杂