linux命令mysql启动,linux中mysql启动服务命令
大家好,又见面了,我是你们的朋友全栈君。
Linux下使用相关命令可以直接启动mysql服务,下面由学习啦小编为大家整理了linux下mysql启动服务命令的相关知识,希望对大家有帮助!
linux的mysql启动服务命令
linux的mysql启动服务命令1:使用mysqld启动、关闭MySQL服务
mysqld是MySQL的守护进程,我们可以用mysqld来启动、关闭MySQL服务,关于mysqld, MySQL 5.6官方介绍资料如下所示:
mysqld, also known as MySQL Server, is the main program that does most of the work in a MySQL installation. MySQL Server manages access to the MySQL data directory that contains databases and tables. The data directory is also the default location for other information such as log files and status files.
When MySQL server starts, it listens for network connections from client programs and manages access to databases on behalf of those clients.
The mysqld program has many options that can be specified at startup. For a complete list of options, run this command:
shell> mysqld –verbose –help
MySQL Server also has a set of system variables that affect its operation as it runs. System variables can be set at server startup, and many of them can be changed at runtime to effect dynamic server reconfiguration. MySQL Server also has a set of status variables that provide information about its operation. You can monitor these status variables to access runtime performance characteristics.
如果MySQL是rpm方式安装的话,mysqld位于/usr/sbin下,如果MySQL是二进制安装的话,mysqld则位于bin目录下面。
[root@localhost ~]# whereis mysqld
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
linux的mysql启动服务命令2:使用mysqld_safe启动、关闭MySQL服务
很多时候,人们会纠结mysqld与mysqld_safe的区别. 其实mysqld_safe是一个脚本,一个非常安全的启动、关闭MySQL服务的脚本。它实际上也是调用mysqld来启动、关闭MySQL服务。关于mysqld_safe,可以参考官方文档mysqld_safe — MySQL Server Startup Script
linux的mysql启动服务命令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
# Should-Start: ypbind nscd ldap ntpd xntpd
# Required-Stop: local_fs network
linux的mysql启动服务命令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”.
linux的mysql启动服务命令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]#
linux的mysql启动服务命令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:
发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/143788.html原文链接:https://javaforall.cn
相关文章
- linux下mysql怎么备份_Linux下如何进行MySQL数据库备份和导入
- MySQL Error number: MY-010086; Symbol: ER_DEPRECATED_TIMESTAMP_IMPLICIT_DEFAULTS; SQLSTATE: HY000 报错 故障修复 远程处理
- Linux中重启VNC服务的指令(linux重启vnc服务)
- 重启MySQL在Linux上的步骤(linux如何重启mysql)
- 服务Linux下查看与重启服务的方法(linux查看进程重启)
- 器Linux服务器上如何删除无用程序(linux删除服务)
- 器Linux中探索NTP服务器之旅(linux查看ntp服务)
- ?Linux:实现更高效的计算和服务(linux有什么用处)
- 联发科推出 Linux 操作系统:全新的使用体验(联发科linux)
- Linux小红帽:开拓新的世界(linux小红帽)
- 器指南:快速安装 MySQL 服务器(安装mysql服务)
- 器安装MySQL服务器:简单步骤指南(如何安装mysql服务)
- Linux文件快速查找字符的方法(linux文件中查找字符)
- 从零开始:Linux下创建目录(linux创建一个目录)
- 深入Linux服务编写实践(linux服务编写)
- 远程连接Linux服务器:SSH的使用(linux的ssh服务)
- 掌握Linux命令之路:走向自由(linux命令路径)
- Linux的分支:分享各操作系统的优势(linux的分支)
- bin探索Linux目录sbin:服务管理神器(linux目录s)
- Linux文件系统大揭秘(linux文件详解)
- MySQL服务到期,请及时续费(mysql到期了)
- 提升Mysql服务安全:开启端口保护(开放mysql端口)
- Linux开端:一段缤纷发展之旅(linux开端口号)
- 器MySQL服务器:系统加速您的商业运行(mysql系统服务)
- 25个关于MySQL服务优化的技巧与方法(mysql服务优化)
- MySQL自动增长——轻松管理大批数据(mysql数据库自动增长)
- 服务Linux 架设邮件服务:一步步到位(linux 搭建邮箱)
- ASP与DW结合MySQL实现强大网站开发(asp dw mysql)
- 使用cmd命令调用MySQL数据库(cmd如何调用mysql)
- MySQL字段汇总之不同之处(mysql 不同字段汇总)
- 速去重MySQL数据去重技巧(mysql不同值怎么快)
- MYSQL离线使用方法大揭秘不联网也能愉快地使用MySQL(mysql 不联网吗)
- MySQL 数据库查询非顺序匹配的方法与技巧(mysql不按顺序匹配)