MySQL学习笔记2-System administration（STOP or START MySQL）

START MYSQL

[root@localhost bin]# service mysql start

Starting MySQL.. SUCCESS! 
[root@localhost bin]# ps -ef | grep mysql
root      5548     1  0 22:00 pts/2    00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid
mysql     5651  5548  7 22:00 pts/2    00:00:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/localhost.localdomain.err --pid-file=/var/lib/mysql/localhost.localdomain.pid
root      5692  3327  0 22:01 pts/2    00:00:00 grep mysql
[root@localhost bin]# cat /var/lib/mysql/localhost.localdomain.err
151117 22:00:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2015-11-17 22:00:54 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-11-17 22:00:54 0 [Note] /usr/sbin/mysqld (mysqld 5.6.27) starting as process 5651 ...
2015-11-17 22:00:54 5651 [Note] Plugin 'FEDERATED' is disabled.
2015-11-17 22:00:54 5651 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-11-17 22:00:54 5651 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-17 22:00:54 5651 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-11-17 22:00:54 5651 [Note] InnoDB: Memory barrier is not used
2015-11-17 22:00:54 5651 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-17 22:00:54 5651 [Note] InnoDB: Using Linux native AIO
2015-11-17 22:00:54 5651 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-17 22:00:54 5651 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-11-17 22:00:54 5651 [Note] InnoDB: Completed initialization of buffer pool
2015-11-17 22:00:54 5651 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-17 22:00:54 5651 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-17 22:00:54 5651 [Note] InnoDB: Waiting for purge to start
2015-11-17 22:00:54 5651 [Note] InnoDB: 5.6.27 started; log sequence number 1625987
2015-11-17 22:00:54 5651 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 9e7e6458-8d33-11e5-a647-000c29ac69e3.
2015-11-17 22:00:54 5651 [Note] Server hostname (bind-address): '*'; port: 3306
2015-11-17 22:00:54 5651 [Note] IPv6 is available.
2015-11-17 22:00:54 5651 [Note]   - '::' resolves to '::';
2015-11-17 22:00:54 5651 [Note] Server socket created on IP: '::'.
2015-11-17 22:00:54 5651 [Note] Event Scheduler: Loaded 0 events
2015-11-17 22:00:54 5651 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.27'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
[root@localhost bin]# cat /var/lib/mysql/localhost.localdomain.pid
5651
[root@localhost bin]# ls -ltr /var/lib/mysql
总用量 110624
drwxr-xr-x. 2 mysql mysql     4096 11月 17 21:33 test
-rw-rw----. 1 mysql mysql 50331648 11月 17 21:33 ib_logfile1
drwx------. 2 mysql mysql     4096 11月 17 21:33 performance_schema
drwx--x--x. 2 mysql mysql     4096 11月 17 21:33 mysql
-rw-r--r--. 1 mysql mysql      125 11月 17 21:33 RPM_UPGRADE_MARKER-LAST
-rw-r--r--. 1 root  root       125 11月 17 21:33 RPM_UPGRADE_HISTORY
-rw-rw----. 1 mysql mysql       56 11月 17 22:00 auto.cnf
srwxrwxrwx. 1 mysql mysql        0 11月 17 22:00 mysql.sock
-rw-rw----. 1 mysql mysql        5 11月 17 22:00 localhost.localdomain.pid
-rw-r-----. 1 mysql root      2112 11月 17 22:00 localhost.localdomain.err
-rw-rw----. 1 mysql mysql 12582912 11月 17 22:00 ibdata1
-rw-rw----. 1 mysql mysql 50331648 11月 17 22:00 ib_logfile0

[root@localhost bin]# 

STOP MYSQL

<<<<

mysqld_safe has no server shutdown capability. You can use mysqladmin shutdown instead. Note that if you forcibly terminate mysqld by using the kill -9 command to send it a signal, then mysqld_safe detects that mysqld terminated abnormally and restarts it. You can work around this by killing mysqld_safe first and then killing mysqld, but it is better to use mysqladmin shutdown, which initiates a normal (clean) server shutdown.

<<<<

[root@localhost bin]# service mysql stop
Shutting down MySQL.. SUCCESS! 
[root@localhost bin]# 

<<< or

[root@localhost ~]# mysqladmin shutdown
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
[root@localhost ~]# mysqladmin -uroot -pmysql shutdown
Warning: Using a password on the command line interface can be insecure.
[root@localhost ~]# ps -ef | grep mysql
root      6112  6073  0 23:46 pts/4    00:00:00 grep mysql
[root@localhost ~]#