Mysql 5.5 資料庫啟動關閉命令
啟動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
./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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle資料庫不同啟動命令和關閉命令全面解析Oracle資料庫
- 資料庫自動啟動關閉資料庫
- 資料庫啟動和關閉資料庫
- rac 管理 啟動關閉資料庫資料庫
- MySQL啟動和關閉命令總結MySql
- RAC 資料庫的啟動與關閉資料庫
- informix 資料庫啟動關閉指令碼ORM資料庫指令碼
- Oracle資料庫的啟動與關閉Oracle資料庫
- Oracle資料庫的啟動和關閉Oracle資料庫
- MySQL 5.5 關閉資料庫報錯"Can't connect to local MySQL server through socket"MySql資料庫Server
- ORACLE資料庫的啟動和關閉(轉)Oracle資料庫
- dataguard standby資料庫的關閉和啟動資料庫
- nginx啟動,重啟,關閉命令Nginx
- db2資料庫的啟動和關閉DB2資料庫
- Oracle 資料庫例項啟動關閉過程Oracle資料庫
- 例項管理及資料庫的啟動關閉資料庫
- 啟動、關閉與資料庫的特殊狀態資料庫
- 啟動/關閉與冷備份Oracle資料庫Oracle資料庫
- 隨系統啟動關閉的oracle資料庫Oracle資料庫
- 啟動MySql資料庫MySql資料庫
- openguass 3.1.0 資料庫啟動,關閉,狀態檢查資料庫
- ORACLE資料庫的啟動和關閉之二(轉)Oracle資料庫
- Oracle資料庫的幾種啟動和關閉方式Oracle資料庫
- 深刻理解Oracle資料庫的啟動和關閉Oracle資料庫
- 深刻理解 oracle 資料庫的啟動和關閉Oracle資料庫
- mysql的啟動和關閉MySql
- oracle資料庫的啟動關閉與各種服務Oracle資料庫
- 【02】Oracle資料庫的例項啟動關閉詳解Oracle資料庫
- oracle資料庫的啟動與關閉過程詳解Oracle資料庫
- 【指令碼】快速啟動和關閉Windows上的資料庫指令碼Windows資料庫
- 深刻理解Oracle資料庫的啟動和關閉(轉)Oracle資料庫
- MySQL資料庫如何啟動?MySql資料庫
- MySQL Windows下關閉和啟動MySqlWindows
- 資料庫關閉資料庫
- MySQL 5.5原始碼安裝時啟動資料庫報錯"Table 'mysql.user' doesn't exist??"MySql原始碼資料庫
- mysql啟動與關閉(手動與自動)MySql
- 開啟關閉oracle資料庫附加日誌Oracle資料庫
- Mysql 5.5 設定資料庫引數MySql資料庫