Mysql 5.5 数据库开启关闭命令
发布时间：2022-04-06 15:41:02 所属栏目：MySql教程 来源：互联网
导读：启动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
|
启动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 （编辑：应用网_丽江站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
浙公网安备 33038102330468号