centos7无法自启动 mysql

问题描述

阿里云ECS 安装了mysql 5.6，使用 systemctl start mysql成功启动mysql，可使用 systemctl enable mysql将mysql加入到开机自启动，可却报错：

[root@go ~]# mysql -Vmysql Ver 14.14 Distrib 5.6.29, for Linux (x86_64) using EditLine wrapper[root@go ~]#[root@go ~]# systemctl enable mysqlFailed to execute operation: No such file or directory[root@go ~]# systemctl enable mariadbFailed to execute operation: No such file or directory[root@go ~]#

使用systemctl enable mariadb 也是一样的，我在Linode中的centos7是直接使用 systemctl enable mariadb 加入自启动的

但是运行 systemctl enable httpd 是没有报错。

[root@go ~]# chkconfigNote: This output shows SysV services only and does not include native systemd services. SysV configuration data might be overridden by native systemd configuration. If you want to list systemd services use ’systemctl list-unit-files’. To see services enabled on particular target use ’systemctl list-dependencies [target]’.aegis 0:off 1:off 2:on 3:on 4:on 5:on 6:offagentwatch 0:off 1:off 2:on 3:on 4:on 5:on 6:offnetconsole 0:off 1:off 2:off 3:off 4:off 5:off 6:offnetwork 0:off 1:off 2:on 3:on 4:on 5:on 6:off[root@go ~]#

问题解答

systemctl list-unit-files 查看下有没有mysql.service 文件

systemctl enable mysqld

systemctl enable mysqld.service

上面层主说的几个命令都试了，还是没有用：ystemctl enable mysqld.servicemysqld.service is not a native service, redirecting to /sbin/chkconfig.Executing /sbin/chkconfig mysqld on[root@iZj6c5y812icw80hzp696gZ ~]# systemctl enable mysqldmysqld.service is not a native service, redirecting to /sbin/chkconfig.Executing /sbin/chkconfig mysqld on[root@iZj6c5y812icw80hzp696gZ ~]# /sbin/chkconfig mysqld onhttp://aliyun.youhuima.cc

===========更新=============

找到了解决方法：编辑文件：vi /etc/rc.d/rc.local增加下面命令，保存/etc/rc.d/init.d/mysqld start

然后添加该文件可执行权限：chmod +x /etc/rc.d/rc.local

经过验证该方案可行。