centOS8安装MySQL8设置开机自动启动失败

提供一个终极解决方案虽然systemctl 更符合管理预期但是不能用
使用一下命令 修改配置文件、修改mysql.service全是问题

systemctl start mysqld
systemctl enable mysqld
systemctl daemon-reload

完全不生效各种报错 提示配置文件内容有问题

Main process exited, code=exited, status=203/EXEC

[Unit]
Description=MySQL Database Server
After=network.target[Service]
Type=forking
User=mysql
Group=mysql
ExecStart=/etc/init.d/mysql start
ExecStop=/etc/init.d/mysql stop
ExecReload=/etc/init.d/mysql reload
Restart=on-failure[Install]
WantedBy=multi-user.target

配置文件修改多次提示的问题都是不一样的

● mysql.service - MySQL Database ServerLoaded: loaded (/etc/systemd/system/mysql.service; enabled; vendor preset: disabled)Active: inactive (dead) since Fri 2025-02-07 11:32:54 CST; 11min agoProcess: 2539 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS)Process: 2497 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS)2月 07 11:32:54 localhost.localdomain systemd[1]: Starting MySQL Database Server...
2月 07 11:32:54 localhost.localdomain mysql[2497]: /etc/init.d/mysql:行239: my_print_defaults: 未找到命令
2月 07 11:32:54 localhost.localdomain mysql[2497]: Starting MySQL ERROR! Couldn't find MySQL server (/usr/local/mysql/bin/mysqld_safe)
2月 07 11:32:54 localhost.localdomain mysql[2539]: /etc/init.d/mysql:行239: my_print_defaults: 未找到命令
2月 07 11:32:54 localhost.localdomain mysql[2539]:  ERROR! MySQL server PID file could not be found!
2月 07 11:32:54 localhost.localdomain systemd[1]: Started MySQL Database Server.

直接修改这个文件 加上

vim /etc/rc.local

/etc/init.d/mysql start 

如果还是不行 加上

echo "Starting MySQL..." > /tmp/rc.local.log
/etc/init.d/mysql start >> /tmp/rc.local.log 2>&1
echo "MySQL start command executed." >> /tmp/rc.local.log

输出一下日志看一下什么问题修改一下即可。