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.
我想要达到的结果

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

查看主机 cat /etc/my.cnf 默认得mysqld配置。一般默认日志是写在在/var/log/mysqld.log里。可以查看日志定位到具体得报错解决。

https://ask.csdn.net/questions/678114?spm=1005.2026.3001.5635&utm_medium=distribute.pc_relevant_ask_down.none-task-ask-2~default~OPENSEARCH~Rate-3.pc_feed_download_top3ask&depth_1-utm_source=distribute.pc_relevant_ask_down.none-task-ask-2~default~OPENSEARCH~Rate-3.pc_feed_download_top3ask

查看日志

其实不难！！

你配置有问题，检查下就行！

要不换个端口试试

题主，大概率是这个问题，你要看下你的配置文件，看下/etc/my.cnf里的配置，尤其是datadir 和 socket 这两个配置，看是否有权限被创建，你要做的是 先给你的这两个配置的文件赋权 chmod -R 777 /var/lib/mysql, 然后删除/var/lib/mysql/目录下的所有文件，注意：如果已有重要数据记得备份
mysql在进行初始化时,会检测目录是否存在
如果不存在,mysql会创建它
如果存在,而且这个目录里有数据,mysql会报错,并且终止初始化
如果以上都没有问题,有可能是因为文件夹权限的问题

my.cnf 问题出在这个配置上