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

經過驗證該方案可行。