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

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日