centos7无法自启动 mysql

Question

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

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

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

---

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

[root@go ~]# chkconfig

Note: 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:off
agentwatch      0:off   1:off   2:on    3:on    4:on    5:on    6:off
netconsole      0:off   1:off   2:off   3:off   4:off   5:off   6:off
network         0:off   1:off   2:on    3:on    4:on    5:on    6:off
[root@go ~]#

Answer 1

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

Answer 2

systemctl enable mysqld

Answer 3

systemctl enable mysqld.service

Answer 4

centos7 应该是: systemctl enable mysqld, 运行的指令也是: systemctl start mysqld

centos7 与centos6还是有些差别的, 这点要注意!

Answer 5

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

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

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

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

经过验证该方案可行。