如何将centOS环境下的MySQL服务改为开机自启动而非手动

1.启动MySQL服务

systemctl start mysqld

2.检查服务是否启动

systemctl status mysqld

 3.查看是否为自启动

systemctl list-unit-files | grep mysqld.service

默认为 enabled 即为自启动，disabled 为非自启动

4.设置为开机自启动

systemctl enable mysqld.service

5.查询即可

[root@atdajv ~]# systemctl list-unit-files | grep mysqld.service
mysqld.service                                enabled 
[root@atdajv ~]#