mysql设置开机自启动

centos 设置 system管理 mysql开机自启

# 在/usr/lib/systemd/system/路径下创建mysql.service

vim /usr/lib/systemd/system/mysql.service

[Unit]
Description=MySQL server
After=syslog.target network.target

[Service]
User=mysql
Group=mysql
Type=forking
TimeoutSec=0
#PermissionsStartOnly=true
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --daemonize
LimitNOFILE = 65535
Restart=on-failure
RestartSec=3
RestartPreventExitStatus=1
PrivateTmp=false

[Install]
WantedBy=multi-user.target

# 重新加载systemctl

systemctl daemon-reload 

# 启动｜重启｜停止mysql
     
systemctl start|restart|stop mysql 

# 设置开机启动/不启动mysql服务

systemctl enable|disable mysql    

# 查看状态
systemctl status mysql