Linux 平台MySQL启动关闭方式总结

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Linux 平台MySQL启动关闭方式总结，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含5084字，纯文字阅读大概需要8分钟。

内容图文

mysqld: /usr/sbin/mysqld /usr/share/man/man8/mysqld.8.gz

[root@localhost ~]# /usr/sbin/mysqld stop

2016-06-27 14:52:54 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2016-06-27 14:52:54 9315 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2016-06-27 14:52:54 9315 [ERROR] Aborting

2016-06-27 14:52:54 9315 [Note] Binlog end

2016-06-27 14:52:54 9315 [Note] /usr/sbin/mysqld: Shutdown complete

[root@localhost ~]# /usr/sbin/mysqld start

2016-06-27 14:52:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2016-06-27 14:52:59 9316 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2016-06-27 14:52:59 9316 [ERROR] Aborting

2016-06-27 14:52:59 9316 [Note] Binlog end

2016-06-27 14:52:59 9316 [Note] /usr/sbin/mysqld: Shutdown complete

 

 

2：使用mysqld_safe启动、关闭MySQL服务

很多时候，人们会纠结mysqld与mysqld_safe的区别. 其实mysqld_safe是一个脚本，一个非常安全的启动、关闭MySQL服务的脚本。它实际上也是调用mysqld来启动、关闭MySQL服务。关于mysqld_safe，可以参考官方文档mysqld_safe — MySQL Server Startup Script

 

3：使用mysql.server启动、关闭MySQL服务

[root@localhost mysql]# ./mysql.server  stop

Shutting down MySQL..[  OK  ]

[root@localhost mysql]# ./mysql.server  start

Starting MySQL..[  OK  ]

[root@localhost mysql]# 

 

mysql.server其实也是一个脚本，它通过调用msqld_safe来启动、关闭MySQL服务。部分脚本脚本如下

[root@localhost mysql]# more mysql.server 

#!/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

 

4：使用mysqld_multi启动、关闭MySQL服务

当服务器上运行了多个MySQL实例时，mysqld_multi是一个非常棒的管理MySQL服务器的工具。当然在使用前，你必须提前做配置

[root@localhost mysql]# /usr/bin/mysqld_multi stop 1

[root@localhost mysql]# /usr/bin/mysqld_multi start 1

mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP ports. It can start or stop servers, or report their current status.

mysqld_multi searches for groups named [mysqldN] in my.cnf (or in the file named by the --defaults-file option). N can be any positive integer. This number is referred to in the following discussion as the option group number, or GNR. Group numbers distinguish option groups from one another and are used as arguments tomysqld_multi to specify which servers you want to start, stop, or obtain a status report for. Options listed in these groups are the same that you would use in the[mysqld] group used for starting mysqld. (See, for example, Section 2.10.5, “Starting and Stopping MySQL Automatically”.) However, when using multiple servers, it is necessary that each one use its own value for options such as the Unix socket file and TCP/IP port number. For more information on which options must be unique per server in a multiple-server environment, see Section 5.6, “Running Multiple MySQL Instances on One Machine”.

 

 

5：使用service 启动、关闭MySQL服务

service mysql start

service mysql stop

service mysql restart

其实如果你对service比较熟悉的话，就会知道运行上面命令，其实是service命令去找/etc/init.d下的相关的mysql脚本去执行启动、关闭动作。

[root@DB-Server init.d]# ls my*

mysql  mysql.server

[root@DB-Server init.d]# 

 

 

6: 使用/etc/init.d/mysql启动、关闭MySQL服务。

 

    如果你非常了解方法5，那么就多了这么一个启动数据库的方式。其实/etc/init.d/mysql也是一个脚本，它调用mysqld_safe脚本来启动MySQL服务。如下所示，你会看到相关代码

[root@DB-Server bin]# /etc/init.d/mysql start

Starting MySQL....[  OK  ]

[root@DB-Server bin]# /etc/init.d/mysql stop

Shutting down MySQL..[  OK  ]

[root@DB-Server bin]# 

 

6：使用mysqladmin关闭数据库

   

      mysqladmin是一个执行管理操作的客户程序，这个命令可以使用安全模式关闭数据库，但是不能启动数据库。当然它可以停止和启动MySQL replication on a slave server

[root@DB-Server bin]# /usr/bin/mysqladmin -u root -p shutdown

Enter password:

 

参考资料：

http://blog.csdn.net/shuishoujushi/article/details/10827471

https://dev.mysql.com/doc/refman/5.6/en/mysqld-safe.html

 

Linux 平台MySQL启动关闭方式总结

标签：

本文系统来源：http://www.cnblogs.com/kerrycode/p/5687791.html

内容总结

以上是互联网集市为您收集整理的Linux 平台MySQL启动关闭方式总结全部内容，希望文章能够帮你解决Linux 平台MySQL启动关闭方式总结所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---