文档课题:MySQL实现开机自启.
数据库:MySQL 8.0.27
1、自启动脚本
Linux中通过编写启动脚本实现MySQL开机自启.
[mysql@leo-827mgr-slave01 ~]$ vi start_mysql.sh
添加如下内容:
#!/bin/bash
# chkconfig: 2345 10 90
# description: Auto-starts mysql
# /etc/init.d/start_mysql.sh
/opt/mysql-8.0.27-linux-glibc2.17-x86_64-minimal/bin/mysqld_safe --defaults-file=/home/mysql/etc/my.cnf &
说明:若未添加蓝色高亮部分,在执行chkconfig –add时会报错” service start_mysql.sh does not support chkconfig”.
2、脚本文件处理
--修改sudoers文件,使mysql可执行root指令.
[root@leo-827mgr-slave01 ~]# vi /etc/sudoers
添加如下:
mysql ALL=(ALL) ALL
--复制启动脚本到系统指定位置,以便系统能够找到并执行它.
[mysql@leo-827mgr-slave01 ~]$ sudo cp /home/mysql/start_mysql.sh /etc/init.d/
[mysql@leo-827mgr-slave01 ~]$ sudo chkconfig --add start_mysql.sh
[mysql@leo-827mgr-slave01 ~]$ sudo chkconfig --level 2345 start_mysql.sh on
[mysql@leo-827mgr-slave01 ~]$ sudo chmod +x /etc/init.d/start_mysql.sh
--确认脚本自启动情况
[mysql@leo-827mgr-slave01 ~]$ sudo chkconfig --list | grep mysql
[sudo] password for mysql:
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]'.
start_mysql.sh 0:off 1:off 2:on 3:on 4:on 5:on 6:off
3、验证自启动情况
[root@leo-827mgr-slave01 ~]# reboot
Last login: Sat Sep 30 14:22:53 2023 from bogon
[root@leo-827mgr-slave01 ~]# ps -ef|grep mysql
root 790 1 0 18:09 ? 00:00:00 /bin/sh /opt/mysql-8.0.27-linux-glibc2.17-x86_64-minimal/bin/mysqld_safe --defaults-file=/home/mysql/etc/my.cnf
mysql 1076 790 1 18:09 ? 00:00:04 /opt/mysql-8.0.27-linux-glibc2.17-x86_64-minimal/bin/mysqld --defaults-file=/home/mysql/etc/my.cnf --basedir=/opt/mysql --datadir=/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/opt/logs/mysql_error.log --pid-file=/mysql/data/mysql.pid --socket=/mysql/data/mysql.sock --port=3306
root 3174 3135 0 18:14 pts/0 00:00:00 grep --color=auto mysql
说明:如上所示,MySQL服务自动启动.
标签:827mgr,--,MySQL,sh,leo,自启,mysql,开机,slave01
From: https://blog.51cto.com/u_12991611/7675359