菩提本无树 明镜亦非台 本来无一物 何处惹尘埃

It's the steady,quiet,plodding ones who win in the lifelong race.

在Linux平台下启动和关闭MySQL服务

首先需要查看下载MySQL服务的状态

[root@localhost bin]# netstat -nlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      1/systemd
tcp        0      0 192.168.122.1:53        0.0.0.0:*               LISTEN      2482/dnsmasq
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1071/sshd
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN      1084/cupsd
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      2289/master
tcp6       0      0 :::3306                 :::*                    LISTEN      52044/mysqld

命令行方式启动和关闭

现在MySQL服务处于启动中,执行下列命令进行关闭操作。

[root@localhost bin]# ./mysqladmin -uroot -p shutdown
Enter password:
171215 09:11:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[1]+  完成                  ./mysqld_safe
[root@localhost bin]# netstat -nlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      1/systemd
tcp        0      0 192.168.122.1:53        0.0.0.0:*               LISTEN      2482/dnsmasq
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1071/sshd
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN      1084/cupsd
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      2289/master
tcp6       0      0 :::111                  :::*                    LISTEN      1/systemd
tcp6       0      0 :::22                   :::*                    LISTEN      1071/sshd
tcp6       0      0 ::1:631                 :::*                    LISTEN      1084/cupsd
tcp6       0      0 ::1:25                  :::*                    LISTEN      2289/master
udp        0      0 192.168.122.1:53        0.0.0.0:*                           2482/dnsmasq
udp        0      0 0.0.0.0:67              0.0.0.0:*                           2482/dnsmasq
udp        0      0 127.0.0.1:323           0.0.0.0:*                           708/chronyd
udp        0      0 0.0.0.0:37653           0.0.0.0:*                           705/avahi-daemon: r
udp        0      0 0.0.0.0:5353            0.0.0.0:*                           705/avahi-daemon: r
udp6       0      0 ::1:323                 :::*                                708/chronyd
raw6       0      0 :::58                   :::*                    7           800/NetworkManager

可以发现MySQL服务已经被关闭。然后执行下列命令来启动服务。

[root@localhost bin]# ./mysqld_safe &
[1] 51836
[root@localhost bin]# 171215 09:19:05 mysqld_safe Logging to '/var/log/mysqld.log'.
171215 09:19:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

[root@localhost bin]# clear
[root@localhost bin]# netstat -nlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      1/systemd
tcp        0      0 192.168.122.1:53        0.0.0.0:*               LISTEN      2482/dnsmasq
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1071/sshd
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN      1084/cupsd
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      2289/master
tcp6       0      0 :::3306                 :::*                    LISTEN      52044/mysqld
[root@localhost bin]# service mysql start
Redirecting to /bin/systemctl start  mysql.service
[root@localhost bin]# netstat -nlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      1/systemd
tcp        0      0 192.168.122.1:53        0.0.0.0:*               LISTEN      2482/dnsmasq
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1071/sshd
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN      1084/cupsd
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      2289/master
tcp6       0      0 :::3306                 :::*                    LISTEN      52044/mysqld

最后再执行命令将MySQL服务关闭,我使用中发现一个问题,就是服务方式打开貌似必须用服务方式关闭。


服务方式启动和关闭

通过服务先打开MySQL服务

[root@localhost bin]# service mysql start
Redirecting to /bin/systemctl start  mysql.service
[root@localhost bin]# netstat -nlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      1/systemd
tcp        0      0 192.168.122.1:53        0.0.0.0:*               LISTEN      2482/dnsmasq
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1071/sshd
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN      1084/cupsd
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      2289/master
tcp6       0      0 :::3306                 :::*                    LISTEN      56017/mysqld

看见MySQL的服务了,再通过服务的方式来关闭服务。

[root@localhost bin]# service mysql stop
Redirecting to /bin/systemctl stop  mysql.service
[root@localhost bin]# netstat -nlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      1/systemd
tcp        0      0 192.168.122.1:53        0.0.0.0:*               LISTEN      2482/dnsmasq
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1071/sshd
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN      1084/cupsd
tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      2289/master
tcp6       0      0 :::111                  :::*                    LISTEN      1/systemd
tcp6       0      0 :::22                   :::*                    LISTEN      1071/sshd
tcp6       0      0 ::1:631                 :::*                    LISTEN      1084/cupsd
tcp6       0      0 ::1:25                  :::*                    LISTEN      2289/master
udp        0      0 192.168.122.1:53        0.0.0.0:*                           2482/dnsmasq
udp        0      0 0.0.0.0:67              0.0.0.0:*                           2482/dnsmasq
udp        0      0 127.0.0.1:323           0.0.0.0:*                           708/chronyd
udp        0      0 0.0.0.0:37653           0.0.0.0:*                           705/avahi-daemon: r
udp        0      0 0.0.0.0:5353            0.0.0.0:*                           705/avahi-daemon: r
udp6       0      0 ::1:323                 :::*                                708/chronyd
raw6       0      0 :::58                   :::*                    7           800/NetworkManager


命令和服务方式的区别

       启动一些程序服务的时候,有时候直接去程序的bin目录下去执行命令,有时候利用service启动。比如启动mysql服务时,大部分喜欢执行service mysql start。当然也可以去mysql下执行bin命令带上几个参数什么的。linux可以man一下,看出来就是去/etc/init.d下执行了可执行的shell脚本。service执行的服务脚本都是在/etc/init.d目录下,各个程序下脚本里执行的命令仍然是在各个bin下。

阅读更多
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/tnt87/article/details/78809146
个人分类: 数据库
上一篇解决Spring中singleton中注入prototype Bean的问题
下一篇《Spring In Action》读书笔记
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭