Linux(CentOS)下设置mysql开机自动启动和chkconfig管理

最新推荐文章于 2024-09-06 16:06:15 发布

mina1113

最新推荐文章于 2024-09-06 16:06:15 发布

阅读量1.2w

点赞数 1

本文链接：https://blog.csdn.net/b_shuang1113/article/details/75635477

版权

本文介绍了如何在CentOS系统下为MySQL设置开机自动启动，并利用chkconfig进行服务管理。首先，在/etc/init.d/目录下创建mysqld脚本文件，然后赋予文件执行权限，确保MySQL服务能在系统启动时自动运行。

摘要由CSDN通过智能技术生成

第一步：在linux系统的/etc/init.d/目录下创建mysqld文件，命令如下：

vim /etc/init.d/mysqld

在脚本中添加如下命令：

#!/bin/sh
# Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB
# This file is public domain and comes with NO WARRANTY of any kind


# MySQL daemon start/stop script.


# Usually this is put in /etc/init.d (at least on machines SYSV R4 based
# systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql.
# When this is done the mysql server will be started when the machine is
# started and shut down when the systems goes down.


# Comments to support chkconfig on RedHat Linux
# chkconfig: 2345 64 36
# description: A very fast and reliable SQL database engine.


# Comments to support LSB init script conventions
### BEGIN INIT INFO
# Provides: mysql
# Required-Start: $local_fs $network $remote_fs
# Should-Start: ypbind nscd ldap ntpd xntpd
# Required-Stop: $local_fs $network $remote_fs
# Default-Start:  2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: start and stop MySQL
# Description: MySQL is a very fast and reliable SQL database engine.
### END INIT INFO


# If you install MySQL on some other places than /usr/local/mysql, then you
# have to do one of the following things for this script to work:
#
# - Run this script from within the MySQL installation directory
# - Create a /etc/my.cnf file with the following information:
#   [mysqld]
#   basedir=<path-to-mysql-installation-directory>
# - Add the above to any other configuration file (for example ~/.my.ini)
#   and copy my_print_defaults to /usr/bin
# - Add the path to the mysql-installation-directory to the basedir variable
#   below.
#
# If you want to affect other MySQL variables, you should make your changes
# in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files.


# If you change base dir, you must also change datadir. These may get
# overwritten by settings in the MySQL configuration files.


basedir=
datadir=


# Default value, in seconds, afterwhich the script should timeout waiting
# for server start.
# Value here is overriden by value in my.cnf.
# 0 means don't wait at all
# Negative numbers mean to wait in