账号密码登录
微信安全登录
微信扫描二维码登录

登录后绑定QQ、微信即可实现信息互通

手机验证码登录
找回密码返回
邮箱找回 手机找回
注册账号返回
其他登录方式
分享
  • 收藏
    X
    ubuntu服务器重启之后启动MySQL失败,是什么原因?
    • 2018-12-19 00:00
    • 10
    136
    0

    重启之前还好好地,重启之后就再也没办法启动了

    root@iZuf6acp86oa3jizjzwaqdZ:~# service mysql start
    Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
    root@iZuf6acp86oa3jizjzwaqdZ:~# systemctl status mysql.service
    ● mysql.service - MySQL Community Server
       Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
       Active: activating (start-post) (Result: exit-code) since Wed 2018-12-19 14:13:09 CST; 22s ago
      Process: 5124 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
      Process: 5116 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
     Main PID: 5124 (code=exited, status=1/FAILURE);         : 5125 (mysql-systemd-s)
       CGroup: /system.slice/mysql.service
               └─control
                 ├─5125 /bin/bash /usr/share/mysql/mysql-systemd-start post
                 └─5194 sleep 1
    
    Dec 19 14:13:09 iZuf6acp86oa3jizjzwaqdZ systemd[1]: Starting MySQL Community Server...
    Dec 19 14:13:11 iZuf6acp86oa3jizjzwaqdZ systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
    
    root@iZuf6acp86oa3jizjzwaqdZ:~# journalctl -xe
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- Unit mysql.service has begun starting up.
    Dec 19 14:31:27 iZuf6acp86oa3jizjzwaqdZ audit[1938]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/1938/status" pid=1938 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=111
    Dec 19 14:31:27 iZuf6acp86oa3jizjzwaqdZ kernel: audit: type=1400 audit(1545201087.234:39): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/1938/status" pid=1938 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=111
    Dec 19 14:31:27 iZuf6acp86oa3jizjzwaqdZ audit[1938]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=1938 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=0
    Dec 19 14:31:27 iZuf6acp86oa3jizjzwaqdZ audit[1938]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/1938/status" pid=1938 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=111
    Dec 19 14:31:27 iZuf6acp86oa3jizjzwaqdZ kernel: audit: type=1400 audit(1545201087.238:40): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=1938 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=0
    Dec 19 14:31:27 iZuf6acp86oa3jizjzwaqdZ kernel: audit: type=1400 audit(1545201087.238:41): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/1938/status" pid=1938 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=111
    Dec 19 14:31:29 iZuf6acp86oa3jizjzwaqdZ systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
    Dec 19 14:31:58 iZuf6acp86oa3jizjzwaqdZ systemd[1]: Failed to start MySQL Community Server.
    -- Subject: Unit mysql.service has failed
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- Unit mysql.service has failed.
    -- 
    -- The result is failed.
    Dec 19 14:31:58 iZuf6acp86oa3jizjzwaqdZ systemd[1]: mysql.service: Unit entered failed state.
    Dec 19 14:31:58 iZuf6acp86oa3jizjzwaqdZ systemd[1]: mysql.service: Failed with result 'exit-code'.
    Dec 19 14:31:58 iZuf6acp86oa3jizjzwaqdZ systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
    Dec 19 14:31:58 iZuf6acp86oa3jizjzwaqdZ systemd[1]: Stopped MySQL Community Server.
    -- Subject: Unit mysql.service has finished shutting down
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- Unit mysql.service has finished shutting down.
    Dec 19 14:31:58 iZuf6acp86oa3jizjzwaqdZ systemd[1]: Starting MySQL Community Server...
    -- Subject: Unit mysql.service has begun start-up
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- Unit mysql.service has begun starting up.
    Dec 19 14:31:58 iZuf6acp86oa3jizjzwaqdZ audit[2036]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2036/status" pid=2036 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=111
    Dec 19 14:31:58 iZuf6acp86oa3jizjzwaqdZ audit[2036]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=2036 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=0
    Dec 19 14:31:58 iZuf6acp86oa3jizjzwaqdZ audit[2036]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2036/status" pid=2036 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=111
    Dec 19 14:31:58 iZuf6acp86oa3jizjzwaqdZ kernel: audit: type=1400 audit(1545201118.491:42): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2036/status" pid=2036 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=111
    Dec 19 14:31:58 iZuf6acp86oa3jizjzwaqdZ kernel: audit: type=1400 audit(1545201118.491:43): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=2036 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=0
    Dec 19 14:31:58 iZuf6acp86oa3jizjzwaqdZ kernel: audit: type=1400 audit(1545201118.491:44): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2036/status" pid=2036 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=111
    Dec 19 14:32:00 iZuf6acp86oa3jizjzwaqdZ systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
    Dec 19 14:32:01 iZuf6acp86oa3jizjzwaqdZ CRON[2068]: pam_unix(cron:session): session opened for user root by (uid=0)
    Dec 19 14:32:01 iZuf6acp86oa3jizjzwaqdZ CRON[2067]: pam_unix(cron:session): session opened for user root by (uid=0)
    Dec 19 14:32:01 iZuf6acp86oa3jizjzwaqdZ CRON[2069]: (root) CMD (php /var/www/html/tiebasign/do.php)
    Dec 19 14:32:01 iZuf6acp86oa3jizjzwaqdZ CRON[2071]: (root) CMD (php /var/www/html/tiebaid/test_only_cli_run_cw123456.php)
    Dec 19 14:32:01 iZuf6acp86oa3jizjzwaqdZ cron[649]: Please install an MTA on this system if you want to use sendmail!
    Dec 19 14:32:01 iZuf6acp86oa3jizjzwaqdZ CRON[2067]: (root) MAIL (mailed 378 bytes of output but got status 0x00ff from MTA
                                                        )
    Dec 19 14:32:01 iZuf6acp86oa3jizjzwaqdZ CRON[2067]: pam_unix(cron:session): session closed for user root
    Dec 19 14:32:01 iZuf6acp86oa3jizjzwaqdZ cron[649]: Please install an MTA on this system if you want to use sendmail!
    Dec 19 14:32:01 iZuf6acp86oa3jizjzwaqdZ CRON[2068]: (root) MAIL (mailed 180 bytes of output but got status 0x00ff from MTA
                                                        )
    Dec 19 14:32:01 iZuf6acp86oa3jizjzwaqdZ CRON[2068]: pam_unix(cron:session): session closed for user root
    Dec 19 14:32:29 iZuf6acp86oa3jizjzwaqdZ systemd[1]: Failed to start MySQL Community Server.
    -- Subject: Unit mysql.service has failed
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- Unit mysql.service has failed.
    -- 
    -- The result is failed.
    Dec 19 14:32:29 iZuf6acp86oa3jizjzwaqdZ systemd[1]: mysql.service: Unit entered failed state.
    Dec 19 14:32:29 iZuf6acp86oa3jizjzwaqdZ systemd[1]: mysql.service: Failed with result 'exit-code'.
    Dec 19 14:32:29 iZuf6acp86oa3jizjzwaqdZ systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
    Dec 19 14:32:29 iZuf6acp86oa3jizjzwaqdZ systemd[1]: Stopped MySQL Community Server.
    -- Subject: Unit mysql.service has finished shutting down
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- Unit mysql.service has finished shutting down.
    Dec 19 14:32:29 iZuf6acp86oa3jizjzwaqdZ systemd[1]: Starting MySQL Community Server...
    -- Subject: Unit mysql.service has begun start-up
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- Unit mysql.service has begun starting up.
    Dec 19 14:32:29 iZuf6acp86oa3jizjzwaqdZ audit[2141]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2141/status" pid=2141 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=111
    Dec 19 14:32:29 iZuf6acp86oa3jizjzwaqdZ kernel: audit: type=1400 audit(1545201149.732:45): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2141/status" pid=2141 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=111
    Dec 19 14:32:29 iZuf6acp86oa3jizjzwaqdZ audit[2141]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=2141 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=0
    Dec 19 14:32:29 iZuf6acp86oa3jizjzwaqdZ kernel: audit: type=1400 audit(1545201149.736:46): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=2141 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=0
    Dec 19 14:32:29 iZuf6acp86oa3jizjzwaqdZ audit[2141]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2141/status" pid=2141 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=111
    Dec 19 14:32:29 iZuf6acp86oa3jizjzwaqdZ kernel: audit: type=1400 audit(1545201149.740:47): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2141/status" pid=2141 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=111 ouid=111
    Dec 19 14:32:31 iZuf6acp86oa3jizjzwaqdZ systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
    lines 2166-2247/2247 (END)
    
    
    2
    打赏
    收藏
    点击回答
    您的回答被采纳后将获得:提问者悬赏的 10 元积分
        全部回答
    • 0
    更多回答
    扫一扫访问手机版
    • 回到顶部
    • 回到顶部