MySQL start and stop

最新推荐文章于 2024-01-14 00:53:16 发布
最新推荐文章于 2024-01-14 00:53:16 发布
阅读量495 收藏
点赞数
分类专栏： mysql

一、本文说明

本实验主要是演示MySQL的四种启动方式，附带停止的操作。

二、mysqld

mysqld is the MySQL server mysqld reads options from the [mysqld] and [server] groups we can invoke mysqld manually.This is usually not done except for debugging purposes.If you invoke the server this way,error messages go to the terminal by default rather than to the error log.

connection

start      

   ./bin/mysqld --defaults-file=./my.cnf --user=mysql    

connect      

    mysql --defaults-file=./my.cnf      

    mysql -S /tmp/mysql.sock

复制代码

—-启动：
[root@node4 mysql5.5]# ./bin/mysqld –defaults-file=./my.cnf –user=mysql &
[1] 11315
[root@node4 mysql5.5]# 130729 0:50:34 InnoDB: The InnoDB memory heap is disabled
130729 0:50:34 InnoDB: Mutexes and rw_locks use InnoDB’s own implementation
130729 0:50:34 InnoDB: Compressed tables use zlib 1.2.3
130729 0:50:34 InnoDB: Initializing buffer pool, size = 128.0M
130729 0:50:34 InnoDB: Completed initialization of buffer pool
130729 0:50:34 InnoDB: highest supported file format is Barracuda.
130729 0:50:34 InnoDB: Waiting for the background threads to start
130729 0:50:35 InnoDB: 1.1.8 started; log sequence number 1595675
130729 0:50:36 [Note] Event Scheduler: Loaded 0 events
130729 0:50:36 [Note] ./bin/mysqld: ready for connections.
Version: ‘5.5.22-log’ socket: ‘/tmp/mysql.sock’ port: 3306 Source distribution

[root@node4 mysql5.5]# ps -ef |grep mysql |grep -v grep
mysql 11315 5333 1 00:50 pts/1 00:00:00 ./bin/mysqld –defaults-file=./my.cnf –user=mysql
—-连接：
[root@node4 mysql5.5]# mysql –defaults-file=./my.cnf
[root@node4 mysql5.5]# mysql -S /tmp/mysql.sock
—-关闭：
[root@node4 mysql5.5]# mysqladmin shutdown

复制代码

三、mysqld_safe
mysqld_safe reads all options the [mysqld],[server],and [mysqld_safe] sections in option files.For backward compatibility,it also reads [safe_mysqld] sections,although you should rename such sections to [mysqd_safe] in MySQL 5.1 installations. mysqld_safe is a shell script that invokes mysqld.The script sets up the error log,and then launches mysqld and monitors it.If mysqld terminates abnormally,mysqld_safe restarts it.

connection 

 start      

    mysqld_safe --defaults-file=./my.cnf --user=mysql &    

 connect      

    mysql --defaults-file=./my.cnf      

    mysql -S /tmp/mysql.sock

复制代码

—-启动：
[root@node4 mysql5.5]# ./bin/mysqld_safe –default-file=./my.cnf –user=mysql &
[1] 11352
[root@node4 mysql5.5]# 130729 00:54:22 mysqld_safe Logging to ‘/opt/mysql5.5/data/node4.err’.
130729 00:54:23 mysqld_safe Starting mysqld daemon with databases from /opt/mysql5.5/data
130729 00:54:25 mysqld_safe mysqld from pid file /opt/mysql5.5/data/node4.pid ended

[1]+ Done ./bin/mysqld_safe –default-file=./my.cnf –user=mysql
—-连接：
[root@node4 mysql5.5]# mysql –defaults-file=./my.cnf
[root@node4 mysql5.5]# mysql -S /tmp/mysql.sock
—-关闭：
[root@node4 mysql5.5]# mysqladmin shutdown

复制代码

四、mysql.server
MySQL distributions on Unix include a script named mysql.server.It can be used on
systems such as Linux and Solaris that use System V-style run directaries to start and stop
system services.It is also used by the Max OS X Startup Item for MySQL.
$MySQL_BASE/share/mysql/mysql.server and support-files/mysql.server
mysql.server reads options from the [mysql.server] and [mysqld] sections of option files.
For backward compatibility,it also reads [mysql_server] sections,although you should rename
such sections to [mysql.server] when using MySQL 5.1
a shell script that invoke mysqld_safe.

connection
start
cd share/mysql
./mysql.server start
cp ./mysql.server /etc/rc.d/init.d/mysql
chkconfig –add mysql
service mysql start
connect
mysql –default-file=./my.cnf
mysql -S /tmp/mysql.sock
复制代码

—-启动：
[root@node4 mysql5.5]# ./support-files/mysql.server start
Starting MySQL… [ OK ]
[root@node4 mysql5.5]# ps -ef |grep mysql |grep -v grep
root 11873 1 1 01:01 pts/1 00:00:00 /bin/sh /opt/mysql5.5/bin/mysqld_safe –datadir=/opt/mysql5.5/data –pid-file=/opt/mysql5.5/data/node4.pid
mysql 12329 11873 4 01:01 pts/1 00:00:00 /opt/mysql5.5/bin/mysqld –basedir=/opt/mysql5.5 –datadir=/opt/mysql5.5/data –plugin-dir=/opt/mysql5.5/lib/plugin –user=mysql –log-error=/opt/mysql5.5/data/node4.err –pid-file=/opt/mysql5.5/data/node4.pid –socket=/tmp/mysql.sock –port=3306
—-设置随系统启动而启动MySQL
[root@node4 mysql5.5]# cp ./support-files/mysql.server /etc/init.d/mysql
[root@node4 mysql5.5]# chkconfig –add mysql
[root@node4 mysql5.5]# chkconfig –list mysql
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[root@node4 mysql5.5]# service mysql start
Starting MySQL.. [ OK ]
[root@node4 mysql5.5]# ps -ef |grep mysql |grep -v grep
root 12423 1 1 01:03 pts/1 00:00:00 /bin/sh /opt/mysql5.5/bin/mysqld_safe –datadir=/opt/mysql5.5/data –pid-file=/opt/mysql5.5/data/node4.pid
mysql 12881 12423 3 01:03 pts/1 00:00:00 /opt/mysql5.5/bin/mysqld –basedir=/opt/mysql5.5 –datadir=/opt/mysql5.5/data –plugin-dir=/opt/mysql5.5/lib/plugin –user=mysql –log-error=/opt/mysql5.5/data/node4.err –pid-file=/opt/mysql5.5/data/node4.pid –socket=/tmp/mysql.sock –port=3306
—连接：
[root@node4 mysql5.5]# mysql –defaults-file=./my.cnf
[root@node4 mysql5.5]# mysql -S /tmp/mysql.sock
—-关闭：
[root@node4 mysql5.5]# mysqladmin shutdown
[root@node4 mysql5.5]# service mysql stop
Shutting down MySQL. [ OK ]

复制代码

五、mysqld_multi
mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP prots.It can start or stop servers,or report their current status.The MySQL Instance Manager is an alternative means of managing multiple servers

how to config 

1). mkdir $MySQL_BASE/data2    

2). mysql_install_db --basedir=$mysql_base              --datadir=$mysql_base/data2              --user=mysql    

3). vi $MySQL_BASE/my.cnf        

     [mysqld_multi]        

     mysqld = /opt/mysql5152/bin/mysqld_safe        

     mysqladmin = /opt/mysql5152/bin/mysqladmin        

     user = test        

     password = test        

     [mysqld3306]         

       .         

       .         

       .     

  4). mysqld_multi --defaults-file=./my.cnf start 3306     

  5). mysql -uroot -P 3306 --protocol=tcp         

       mysql -S /tmp/mysql3306.sock     

   6). GRANT SHUTDOWN ON *.* TO 'test'@'localhost' IDENTIFIED BY 'test';     

   7). mysqld_multi --defaults-file=./my.cnf stop 3306

复制代码

—-创建存放数据库的目录
[root@node4 mysql5.5]# mkdir data2
—-创建数据库基表
[root@node4 mysql5.5]# ./scripts/mysql_install_db –basedir=/opt/mysql5.5 –datadir=/opt/mysql5.5/data2 –user=mysql
Installing MySQL system tables…
130729 1:35:52 [Warning] You need to use –log-bin to make –binlog-format work.
OK
Filling help tables…
130729 1:35:52 [Warning] You need to use –log-bin to make –binlog-format work.
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/opt/mysql5.5/bin/mysqladmin -u root password ‘new-password’
/opt/mysql5.5/bin/mysqladmin -u root -h node4 password ‘new-password’

Alternatively you can run:
/opt/mysql5.5/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /opt/mysql5.5 ; /opt/mysql5.5/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd /opt/mysql5.5/mysql-test ; perl mysql-test-run.pl

Please report any problems with the /opt/mysql5.5/scripts/mysqlbug script!
—-修改data2目录的属主
[root@node4 mysql5.5]# chown -R mysql:mysql data2/
—-修改my.conf文件，添加下面的内容
[root@node4 mysql5.5]# more my.cnf
[mysqld_multi]
mysqld = /opt/mysql5.5/bin/mysqld_safe
mysqladmin = /opt/mysql5.5/bin/mysqladmin
user = test
password = test

The MySQL server

[mysqld3306]
port = 3306
socket = /tmp/mysql3306.sock
pid-file = /tmp/mysql3306.pid
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
basedir = /opt/mysql5.5
datadir = /opt/mysql5.5/data
log-error = /tmp/mysql3306.err

[mysqld3307]
port = 3307
socket = /tmp/mysql3307.sock
pid-file = /tmp/mysql3307.pid
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
basedir = /opt/mysql5.5
datadir = /opt/mysql5.5/data2
log-error = /tmp/mysql3307.err
—-启动3306
[root@node4 mysql5.5]# ./bin/mysqld_multi –defaults-file=./my.cnf start 3306 &
[1] 13184
[root@node4 mysql5.5]# ps -ef |grep 3306 |grep -v grep
root 13192 1 0 01:52 pts/1 00:00:00 /bin/sh /opt/mysql5.5/bin/mysqld_safe –port=3306 –socket=/tmp/mysql3306.sock –pid-file=/tmp/mysql3306.pid –skip-external-locking –key_buffer_size=16M –max_allowed_packet=1M –table_open_cache=64 –sort_buffer_size=512K –net_buffer_length=8K –read_buffer_size=256K –read_rnd_buffer_size=512K –myisam_sort_buffer_size=8M –basedir=/opt/mysql5.5 –datadir=/opt/mysql5.5/data –log-error=/tmp/mysql3306.err
mysql 13637 13192 1 01:52 pts/1 00:00:00 /opt/mysql5.5/bin/mysqld –basedir=/opt/mysql5.5 –datadir=/opt/mysql5.5/data –plugin-dir=/opt/mysql5.5/lib/plugin –user=mysql –skip-external-locking –key-buffer-size=16M –max-allowed-packet=1M –table-open-cache=64 –sort-buffer-size=512K –net-buffer-length=8K –read-buffer-size=256K –read-rnd-buffer-size=512K –myisam-sort-buffer-size=8M –log-error=/tmp/mysql3306.err –pid-file=/tmp/mysql3306.pid –socket=/tmp/mysql3306.sock –port=3306
[1]+ Done ./bin/mysqld_multi –defaults-file=./my.cnf start 3306
—-启动3307
[root@node4 mysql5.5]# ./bin/mysqld_multi –defaults-file=./my.cnf start 3307 &
[1] 13658
[root@node4 mysql5.5]# ps -ef |grep 3307 |grep -v grep
root 13666 1 1 01:53 pts/1 00:00:00 /bin/sh /opt/mysql5.5/bin/mysqld_safe –port=3307 –socket=/tmp/mysql3307.sock –pid-file=/tmp/mysql3307.pid –skip-external-locking –key_buffer_size=16M –max_allowed_packet=1M –table_open_cache=64 –sort_buffer_size=512K –net_buffer_length=8K –read_buffer_size=256K –read_rnd_buffer_size=512K –myisam_sort_buffer_size=8M –basedir=/opt/mysql5.5 –datadir=/opt/mysql5.5/data2 –log-error=/tmp/mysql3307.err –log-bin=mysql-bin –binlog_format=mixed –server-id=1
mysql 14156 13666 11 01:53 pts/1 00:00:00 /opt/mysql5.5/bin/mysqld –basedir=/opt/mysql5.5 –datadir=/opt/mysql5.5/data2 –plugin-dir=/opt/mysql5.5/lib/plugin –user=mysql –skip-external-locking –key-buffer-size=16M –max-allowed-packet=1M –table-open-cache=64 –sort-buffer-size=512K –net-buffer-length=8K –read-buffer-size=256K –read-rnd-buffer-size=512K –myisam-sort-buffer-size=8M –log-bin=mysql-bin –binlog-format=mixed –server-id=1 –log-error=/tmp/mysql3307.err –pid-file=/tmp/mysql3307.pid –socket=/tmp/mysql3307.sock –port=3307
[1]+ Done ./bin/mysqld_multi –defaults-file=./my.cnf start 3307
—-对数据库的连接
[root@node4 mysql5.5]# mysql -S /tmp/mysql3306.sock
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.22 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> exit;
Bye
[root@node4 mysql5.5]# mysql -S /tmp/mysql3307.sock
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.22-log Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> exit;
Bye
—-关闭3306，首先需要连接数据库，创建test用户并授予它权限，最后使用mysqld_multi关闭3306
[root@node4 mysql5.5]# mysql -S /tmp/mysql3306.sock
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.22 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> GRANT SHUTDOWN ON . TO ‘test’@’localhost’ identified by ‘test’ with grant option;
Query OK, 0 rows affected (0.11 sec)

mysql> exit;
Bye
[root@node4 mysql5.5]# ./bin/mysqld_multi –defaults-file=./my.cnf stop 3306
[root@node4 mysql5.5]# ps -ef |grep 3306 |grep -v grep

复制代码

risen16
关注
专栏目录
MySQL- 快捷- start / stop
伫庭观雨
03-12 470
目录 一、条件 二、打开 - MySQL 三、关闭 - MySQL 四、我一般在任务栏新建一个工具栏，方便使用 一、条件 已经安装MySQL 高频使用MySQL 二、打开 - MySQL 桌面新建：文本文档 重命名：Mysql_start.bat 全选脚本 - 复制- 粘贴到Mysql_start.bat 保存 - 双击运行 @echo off mo...
start and stop mysql_无法启动mysql服务
weixin_32691939的博客
01-27 1533
我无法从我的ubuntu服务器重启我的mysql服务.这是错误：● mysql.service - LSB: Start and stop the mysql database server daemonLoaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)Active: failed (Result: exit-code) ...
MySQL启动报错： Failed to start LSB start and stop MySQL
一直在水些技术小文
03-23 9948
MySQL启动报错： Failed to start LSB: start and stop MySQL.与连接而数据库报错：ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) 今天在配置部署一台MySQL服务器，安装成功后，自动启动了 mysql服务，此时默认的mysql的data是在/var/lib/mysql下的，我想把他改成/mysql/mysql
start and stop mysql_MySQL学习笔记2-System administration（STOP or START MySQL）
weixin_28842269的博客
02-11 113
START MYSQL[root@localhost bin]# service mysql startStarting MySQL.. SUCCESS![root@localhost bin]# ps -ef | grep mysqlroot 5548 1 0 22:00 pts/2 00:00:00 /bin/sh /usr/bin/mysqld_safe --dat...
MySQL启动报错： Failed to start LSB: start and stop MySQL.
热门推荐
chan__csdn的博客
07-13 3万+
MySQL启动报错： Failed to start LSB: start and stop MySQL.与连接而数据库报错：ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) 今天在配置部署一台MySQL服务器，安装成功后，自动启动了 mysql服务，此时默认的mysql的data是在/var/lib/mysql下的，我想把他改成/mysql/mysql
linux下mysql提示"mysql deamon failed to start"错误的解决方法
09-10
首先，当执行`service mysql start`或`service mysqld start`时遇到“mysql deamon failed to start”错误，第一步是检查MySQL的日志文件以获取更详细的错误信息。在本例中，可以通过`less /var/log/mysqld.log`来...
mysql的使用(net stop/start mysql80 拒绝访问)
tumu6889的博客
07-31 4216
mysql 启动
mysql-bin position_mysqlbinlog基于某个偏移量进行数据的恢复(重做),--start-position,--stop-position的使用方法...
weixin_30495795的博客
01-18 1861
需求描述:今天在看mysqlbinlog的内容,看到了--start-position和--stop-position这些选项,就测试下这个参数具体该怎么进行使用呢,在此记录下.操作过程:1.通过mysqlbinlog以文本的格式查看某个binlog的内容[mysql@redhat6 data]$mysqlbinlog mysql-bin.000027 | more/*!50530 SET @@S...
启动和暂停MySQL服务器的两种方式
m0_70545163的博客
06-11 4864
摘要：本文将介绍两种方式来启动和暂停服务器，一是通过计算机管理找到MySQL服务，进而启动和暂停MySQL的服务；二是使用DOS命令来启动和暂停MySQL的服务。同时，以上两种方式都可以对计算机的其他服务进行启动、暂停等操作。
MySQL--启动和关闭MySQL服务
c851204293的博客
11-21 409
  MySQL--启动和关闭MySQL服务   目录   1.Windows下 启动服务 关闭服务 2.Linux下 启动服务 关闭服务 重启服务 1.Windows下 启动服务 mysqld --console　　 或　　net start mysql　　 关闭服务 mysqladmin -uroot shudown　　 或　　net st...
linux mysql stop 报错_mysql linux上安装使用
weixin_32535637的博客
01-27 368
安装启动安装之前可以看下系统中有没有已经安装。查看所有软件：dpkg -l1、查看mysql安装的版本mysql --version2、mysql状态service mysql status3、打开数据库service mysql start 4、关闭数据库：service mysql stop不会有输出内容，继续输入service mysql status 5、异常：controlproc...
linux stop mysql_如何在linux下重启MySQL数据库
weixin_27388739的博客
02-26 253
从程序安装包安装的Mysql，在系统中没有红帽常用的servcie mysqld restart这个脚本，因此重启MYSQL数据库只好手工重启，直接执行Killall mysql，强制终止的话，将可能造成表的损坏，一旦造成表损坏，那损失是巨大的。在这里推荐安全的重启方法$mysql_dir/bin/mysqladmin -u root -p shutdown$mysql_dir/bin/safe_...
mysql start_MySQL start and stop
weixin_28717807的博客
01-18 248
一、本文说明本实验主要是演示MySQL的四种启动方式，附带停止的操作。二、mysqldmysqld is the MySQL server mysqld reads options from the [mysqld] and [server] groups we can invoke mysqld manually.This is usually not done except for d...
用service命令管理mysql启停
w13707470416的博客
03-26 1368
安装完成mysql之后，每次启动和停止都很麻烦，有时候记不住去网上搜一下，看见大家都用service来进行服务的管理，试了一下，果然好用。推荐大家也要这么用，如果你的服务器版本高于centos7，可以使用systemd命令（取代service命令）来管理。 启动和停止mysql服务 # 启动 /usr/local/mysql/bin/mysqld --basedir=/usr/local/m...
MySQL服务的启动和停止
最新发布
weixin_44620012的博客
01-14 388
net start 服务名(启动服务)net stop 服务名(停止服务)方式一：计算机一右击管理一服务。MySQL服务的启动和停止。方式二：通过管理员身份运行。
mysql start stop_mysql服务的启动和停止netstopmysqlnetstartmysql
weixin_42352351的博客
01-19 347
第一招、mysql服务的启动和停止 net stop mysql net start mysql 第二招、登陆mysql 语法如下： mysql -u用户名-p用户密码 键入命令mysql -uroot -p，回车后提示你输入密码，输入12345，然后回车即可进入到mysql中了，mysql的提示符是： mysql 注意，如果是第一招、mysql服务的启动和停止net stop mysqlnet ...
mysql 启动，停止，查询运行状况命令
lppl010_的专栏
05-23 1667
查看mysql运行情况 mysqladmin -u username -p(回车，然后输入密码) 启动mysql，必须和系统中mysql服务名字一样 net start MYSQL57 停止MYSQL net stop MYSQL57
start and stop the mysql
05-17
If you are running MySQL on a Windows system, you can start and stop it using the Services app. To access the Services app, follow these steps: 1. Open the Start menu and type "services" in the ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值