Mysql 5.5 数据库启动关闭命令

发布时间:2020-08-09 14:08:23 作者:410192979
来源:ITPUB博客 阅读:223
启动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
推荐阅读:
  1. centos6.5 安装mysql-5.5
  2. MySQL半同步复制

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

mysql 命令 数据库

上一篇:又是一个github吗? Kubernetes 初创公司 Heptio被VMware 收购

下一篇:【Zabbix】教你搭建elasticsearch与实现zabbix对接

相关阅读

您好,登录后才能下订单哦!

密码登录
登录注册
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》