centos7.x设置mysql自启动 - smile0821/learngit GitHub Wiki

新增配置文件

whereis mysql
cd /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
vi /etc/systemd/system/mysqld.service

mysql.service文件内容:

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000

添加到开机自启

systemctl enable mysqld.service
systemctl start mysqld
systemctl stop mysqld
systemctl status mysqld