• ADADADADAD

    Mysql 5.5 数据库启动关闭命令[ mysql数据库 ]

    mysql数据库 时间:2024-12-03 12:14:58

    作者:文/会员上传

    简介:

    启动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:

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。

    启动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
    Mysql 5.5 数据库启动关闭命令.docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: mysql命令数据库