Home Sign Up Sign In
V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member  Sign In
• 请不要在回答技术问题时复制粘贴 AI 生成的内容
kmdd33
V2EX  ›  程序员

centos7 安装 mysql 卡住了，输入： sudo systemctl start mysqld 后， 光标停在那里一动不动

  •   
  •   kmdd33 · Apr 15, 2018 · 14387 views
    This topic created in 2947 days ago, the information mentioned may be changed or developed.

    参考的教程： https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-centos-7 https://linode.com/docs/databases/mysql/how-to-install-mysql-on-centos-7/

    环境：cetnos7，openresty，已经安装好了 php7，infophp 也显示正常，之前安装了 mariadb，卸载了，现在安装 mysql5.5

    执行命令的过程：

    sudo yum install mysql-server

    Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile

    sudo systemctl start mysqld

    （输入这个命令后，光标就卡在这里了）

    请问具体的解决方案？

  • sudo
  • MySQL
  • systemctl
  • mysqld
    24 replies  •  2018-04-16 20:38:03 +08:00
    neighbads
        1
    neighbads  
       Apr 15, 2018
    你不看日志的吗。。。
    kmdd33
        2
    kmdd33  
    OP
       Apr 15, 2018
    @neighbads 请问日志目录？
    defunct9
        3
    defunct9  
       Apr 15, 2018 via iPhone   ❤️ 3
    开 ssh,我上去装
    kmdd33
        4
    kmdd33  
    OP
       Apr 15, 2018
    ／ var/log/mysqld.log 的日志
    @neighbads 不知道你指的是不是这个？



    180415 10:39:22 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
    180415 10:49:22 mysqld_safe Logging to '/var/log/mysqld.log'.
    180415 10:49:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    180415 10:49:22 [Note] /usr/sbin/mysqld (mysqld 5.5.59) starting as process 13415 ...
    180415 10:49:22 [Note] Plugin 'FEDERATED' is disabled.
    180415 10:49:22 InnoDB: The InnoDB memory heap is disabled
    180415 10:49:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    180415 10:49:22 InnoDB: Compressed tables use zlib 1.2.3
    180415 10:49:22 InnoDB: Using Linux native AIO
    180415 10:49:22 InnoDB: Initializing buffer pool, size = 128.0M
    180415 10:49:22 InnoDB: Completed initialization of buffer pool
    180415 10:49:22 InnoDB: highest supported file format is Barracuda.
    180415 10:49:22 InnoDB: Waiting for the background threads to start
    180415 10:49:23 InnoDB: 5.5.59 started; log sequence number 1597945
    180415 10:49:23 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    180415 10:49:23 [Note] - '0.0.0.0' resolves to '0.0.0.0';
    180415 10:49:23 [Note] Server socket created on IP: '0.0.0.0'.
    180415 10:49:23 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
    180415 10:49:23 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
    180415 10:49:23 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.59' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
    wwqgtxx
        5
    wwqgtxx  
       Apr 15, 2018
    sudo journalctl -u mysqld
    kmdd33
        6
    kmdd33  
    OP
       Apr 15, 2018
    sudo journalctl -u mysqld
    -- Logs begin at Wed 2018-04-11 00:59:13 UTC, end at Sun 2018-04-15 10:56:42 UTC. --
    Apr 15 09:58:20 newoneacreland systemd[1]: Starting MySQL Community Server...
    Apr 15 09:58:21 newoneacreland mysqld_safe[31839]: 180415 09:58:21 mysqld_safe Logging to '/var/log/mysqld.log'.
    Apr 15 09:58:22 newoneacreland mysqld_safe[31839]: 180415 09:58:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    Apr 15 10:08:21 newoneacreland systemd[1]: mysqld.service start-post operation timed out. Stopping.
    Apr 15 10:08:21 newoneacreland systemd[1]: Failed to start MySQL Community Server.
    Apr 15 10:08:21 newoneacreland systemd[1]: Unit mysqld.service entered failed state.
    Apr 15 10:08:21 newoneacreland systemd[1]: mysqld.service failed.
    Apr 15 10:08:22 newoneacreland systemd[1]: mysqld.service holdoff time over, scheduling restart.
    Apr 15 10:08:22 newoneacreland systemd[1]: Starting MySQL Community Server...
    Apr 15 10:08:22 newoneacreland mysqld_safe[2173]: 180415 10:08:22 mysqld_safe Logging to '/var/log/mysqld.log'.
    Apr 15 10:08:23 newoneacreland mysqld_safe[2173]: 180415 10:08:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    Apr 15 10:18:22 newoneacreland systemd[1]: mysqld.service start-post operation timed out. Stopping.
    Apr 15 10:18:22 newoneacreland systemd[1]: Failed to start MySQL Community Server.
    Apr 15 10:18:22 newoneacreland systemd[1]: Unit mysqld.service entered failed state.
    Apr 15 10:18:22 newoneacreland systemd[1]: mysqld.service failed.
    Apr 15 10:18:23 newoneacreland systemd[1]: mysqld.service holdoff time over, scheduling restart.
    Apr 15 10:18:23 newoneacreland systemd[1]: Starting MySQL Community Server...
    Apr 15 10:18:24 newoneacreland mysqld_safe[4906]: 180415 10:18:24 mysqld_safe Logging to '/var/log/mysqld.log'.
    Apr 15 10:18:24 newoneacreland mysqld_safe[4906]: 180415 10:18:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    Apr 15 10:28:23 newoneacreland systemd[1]: mysqld.service start-post operation timed out. Stopping.
    Apr 15 10:28:23 newoneacreland systemd[1]: Failed to start MySQL Community Server.
    Apr 15 10:28:23 newoneacreland systemd[1]: Unit mysqld.service entered failed state.
    Apr 15 10:28:23 newoneacreland systemd[1]: mysqld.service failed.
    Apr 15 10:28:24 newoneacreland systemd[1]: mysqld.service holdoff time over, scheduling restart.
    Apr 15 10:28:24 newoneacreland systemd[1]: Starting MySQL Community Server...
    Apr 15 10:28:24 newoneacreland mysqld_safe[7562]: 180415 10:28:24 mysqld_safe Logging to '/var/log/mysqld.log'.
    Apr 15 10:28:25 newoneacreland mysqld_safe[7562]: 180415 10:28:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    lines 1-28...skipping...
    -- Logs begin at Wed 2018-04-11 00:59:13 UTC, end at Sun 2018-04-15 10:56:42 UTC. --
    Apr 15 09:58:20 newoneacreland systemd[1]: Starting MySQL Community Server...
    Apr 15 09:58:21 newoneacreland mysqld_safe[31839]: 180415 09:58:21 mysqld_safe Logging to '/var/log/mysqld.log'.
    Apr 15 09:58:22 newoneacreland mysqld_safe[31839]: 180415 09:58:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    Apr 15 10:08:21 newoneacreland systemd[1]: mysqld.service start-post operation timed out. Stopping

    @wwqgtxx
    kmdd33
        7
    kmdd33  
    OP
       Apr 15, 2018

    截图在这里，麻烦看下，谢谢 @wwqgtxx @neighbads @defunct9
    kmdd33
        8
    kmdd33  
    OP
       Apr 15, 2018


    /etc/my.cnf 的配置截图如上




    /var/log/mysqld.log 的配置截图如上

    @wwqgtxx @neighbads @defunct9
    f2f2f
        9
    f2f2f  
       Apr 15, 2018
    怎么印象里 centos7 并不支持 mysql 5.5 呀……
    LGB
        10
    LGB  
       Apr 15, 2018 via Android
    看错误日志。
    kmdd33
        11
    kmdd33  
    OP
       Apr 15, 2018
    /usr/local/openresty/nginx/logs/error.log



    @LGB
    kmdd33
        12
    kmdd33  
    OP
       Apr 15, 2018
    defunct9
        13
    defunct9  
       Apr 15, 2018 via iPhone
    猜火车🚄
    kmdd33
        14
    kmdd33  
    OP
       Apr 15, 2018
    输入 sudo journalctl -xe -u mariadb.service
    查看信息
    然后输入：
    /usr/bin/mysql_secure_installation
    按照提示 输入 enter
    然后输入 4 个 y
    然后 sudo systemctl status mysqld
    active 的状态
    sudo systemctl start mysqld
    成功

    谢谢各位
    Beebird
        15
    Beebird  
       Apr 15, 2018
    之前卸载的时候，恐怕没有移除 /var/lib/mysql，mariadb-server 和 mysql-server 是默认相同的 db 文件位置。
    zhazi
        16
    zhazi  
       Apr 15, 2018 via Android
    我猜是磁盘满了
    venpong
        17
    venpong  
       Apr 15, 2018 via Android
    建议 lnmp 一键安装
    zhjits
        18
    zhjits  
       Apr 15, 2018
    MySQL 启动日常
    sudo systemctl start mysql --no-block; sudo journalctl -xefu mysql
    这样一旦挂了你能知道发生了什么
    julyclyde
        19
    julyclyde  
       Apr 15, 2018
    @venpong 你那种一键安装是最容易出事的，因为你根本不知道它是咋运行的
    kmdd33
        20
    kmdd33  
    OP
       Apr 16, 2018
    @zhazi thanks
    keithszc
        21
    keithszc  
       Apr 16, 2018
    想问一下，在 centos7 环境下，mariadb 和 mysql 有什么区别吗？
    最近我刚好在弄个东西，卸了 mysql 装的 mariadb，一个在官方包里面，一个不在，但是用起来并没有什么区别。
    wizardoz
        22
    wizardoz  
       Apr 16, 2018
    其实 MySQL 这种应用最适合用 docker 跑了，避开操作系统兼容性问题和多版本共存问题。
    YumeMichi
        23
    YumeMichi  
       Apr 16, 2018
    @keithszc madiadb 是 mysql 的社区版
    julyclyde
        24
    julyclyde  
       Apr 16, 2018
    @wizardoz mysql 这种东西，为什么会有多版本并存以及经常更换底层操作系统的需求？
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   841 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 85ms · UTC 20:51 · PVG 04:51 · LAX 13:51 · JFK 16:51
    ♥ Do have faith in what you're doing.