Mysql 5.5 数据库启动关闭命令

港控/mmm° 2024-04-17 23:54 69阅读 0赞

**启动MySQL服务**  
**./bin/mysqld\_safe --defaults-file=/etc/my.cnf &**  
  
\[1\] 21698  
\[root@localhost bin\]\# 160402 05:57:36 mysqld\_safe Logging to '/log/err.log'.  
160402 05:57:36 mysqld\_safe Starting mysqld daemon with databases from /var/lib/mysql  
  
error日志中的记录如下：  
  
160402 05:57:36 mysqld\_safe Starting mysqld daemon with databases from /var/lib/mysql  
160402  5:57:36 \[Note\] /data/bin/mysqld (mysqld 5.5.48-log) starting as process 22108 ...  
160402  5:57:36 InnoDB: The InnoDB memory heap is disabled  
160402  5:57:36 InnoDB: Mutexes and rw\_locks use GCC atomic builtins  
160402  5:57:36 InnoDB: Compressed tables use zlib 1.2.3  
160402  5:57:36 InnoDB: Using Linux native AIO  
160402  5:57:36 InnoDB: Initializing buffer pool, size = 100.0M  
160402  5:57:36 InnoDB: Completed initialization of buffer pool  
160402  5:57:36 InnoDB: highest supported file format is Barracuda.  
160402  5:57:37  InnoDB: Waiting for the background threads to start  
160402  5:57:38 InnoDB: 5.5.48 started; log sequence number 1595675  
160402  5:57:38 \[Note\] Server hostname (bind-address): '0.0.0.0'; port: 3306  
160402  5:57:38 \[Note\]   - '0.0.0.0' resolves to '0.0.0.0';  
160402  5:57:38 \[Note\] Server socket created on IP: '0.0.0.0'.  
160402  5:57:38 \[Note\] Event Scheduler: Loaded 0 events  
160402  5:57:38 \[Note\] /data/bin/mysqld: ready for connections.  
Version: '5.5.48-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  production environment  
  
**关闭MySQL服务**  
**./bin/mysqladmin -u root -p shutdown**  
  
Enter password:   
160402 05:56:10 mysqld\_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended  
\[1\]+  Done                    ./mysqld\_safe --defaults-file=/etc/my.cnf  
  
error日志中的记录如下：  
  
160402  5:56:09 \[Note\] /data/bin/mysqld: Normal shutdown  
  
160402  5:56:09 \[Note\] Event Scheduler: Purging the queue. 0 events  
160402  5:56:09  InnoDB: Starting shutdown...  
160402  5:56:10  InnoDB: Shutdown completed; log sequence number 1595675  
160402  5:56:10 \[Note\] /data/bin/mysqld: Shutdown complete  
  
160402 05:56:10 mysqld\_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2074329/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2074329/