系统崩溃后，无法通过套接字连接到本地mysql服务器

xfyts7mz  于 2021-06-21  发布在  Mysql
关注(0)|答案(0)|浏览(232)

我的笔记本电脑突然崩溃与bsd和后重新启动和登录，mysql是造成我的问题。
我在ubuntu上使用vagrant和mysql。

root@dev:/var/lib/mysql# 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.

运行systemctl status mysql.service显示以下内容


* mysql.service - LSB: Start and stop the mysql database server daemon

Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
Active: failed (Result: exit-code) since Thu 2018-01-04 11:08:55 GMT; 
14s ago
Docs: man:systemd-sysv-generator(8)
Process: 19954 ExecStart=/etc/init.d/mysql start (code=exited, 
status=1/FAILURE)

Jan 04 11:08:55 dev /etc/init.d/mysql[20425]: 0 processes alive and 
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' 
resulted in
Jan 04 11:08:55 dev /etc/init.d/mysql[20425]: [61B blob data]
Jan 04 11:08:55 dev /etc/init.d/mysql[20425]: error: 'Can't connect to 
local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jan 04 11:08:55 dev /etc/init.d/mysql[20425]: Check that mysqld is 
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 04 11:08:55 dev /etc/init.d/mysql[20425]:
Jan 04 11:08:55 dev mysql[19954]:    ...fail!
Jan 04 11:08:55 dev systemd[1]: mysql.service: Control process exited, 
code=exited status=1
Jan 04 11:08:55 dev systemd[1]: Failed to start LSB: Start and stop the 
mysql database server daemon.
Jan 04 11:08:55 dev systemd[1]: mysql.service: Unit entered failed 
state.
Jan 04 11:08:55 dev systemd[1]: mysql.service: Failed with result 
'exit-code'.

运行journalctl-xe显示以下内容

Jan 04 11:08:53 dev kernel: audit: type=1400 audit(1515064133.370:391): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=20386 comm="mysqld" requested_ma
Jan 04 11:08:54 dev audit[20397]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/my.cnf" pid=20397 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Jan 04 11:08:54 dev audit[20397]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=20397 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 oui
Jan 04 11:08:54 dev kernel: audit: type=1400 audit(1515064134.382:392): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/my.cnf" pid=20397 comm="mysqld" requested_mask="r" denied_m
Jan 04 11:08:54 dev kernel: audit: type=1400 audit(1515064134.382:393): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=20397 comm="mysqld" requested_ma
Jan 04 11:08:55 dev audit[20408]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/my.cnf" pid=20408 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Jan 04 11:08:55 dev audit[20408]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=20408 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 oui
Jan 04 11:08:55 dev kernel: audit: type=1400 audit(1515064135.398:394): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/my.cnf" pid=20408 comm="mysqld" requested_mask="r" denied_m
Jan 04 11:08:55 dev kernel: audit: type=1400 audit(1515064135.398:395): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=20408 comm="mysqld" requested_ma
Jan 04 11:08:55 dev audit[20418]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/my.cnf" pid=20418 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
Jan 04 11:08:55 dev audit[20418]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=20418 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 oui
Jan 04 11:08:55 dev kernel: audit: type=1400 audit(1515064135.410:396): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/my.cnf" pid=20418 comm="mysqld" requested_mask="r" denied_m
Jan 04 11:08:55 dev kernel: audit: type=1400 audit(1515064135.410:397): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/etc/mysql/my.cnf.fallback" pid=20418 comm="mysqld" requested_ma
Jan 04 11:08:55 dev /etc/init.d/mysql[20425]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 04 11:08:55 dev /etc/init.d/mysql[20425]: [61B blob data]
Jan 04 11:08:55 dev /etc/init.d/mysql[20425]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jan 04 11:08:55 dev /etc/init.d/mysql[20425]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 04 11:08:55 dev /etc/init.d/mysql[20425]:
Jan 04 11:08:55 dev mysql[19954]:    ...fail!
Jan 04 11:08:55 dev systemd[1]: mysql.service: Control process exited, code=exited status=1
Jan 04 11:08:55 dev systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
-- 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.
Jan 04 11:08:55 dev systemd[1]: mysql.service: Unit entered failed state.
Jan 04 11:08:55 dev systemd[1]: mysql.service: Failed with result 'exit-code'.
Jan 04 11:09:01 dev CRON[20427]: pam_unix(cron:session): session opened for user root by (uid=0)
Jan 04 11:09:01 dev CRON[20428]: (root) CMD (  [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Jan 04 11:09:01 dev CRON[20427]: pam_unix(cron:session): session closed for user root
Jan 04 11:09:02 dev systemd[1]: Starting Clean php session files...
-- Subject: Unit phpsessionclean.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit phpsessionclean.service has begun starting up.
Jan 04 11:09:02 dev sessionclean[20429]: Cannot load Xdebug - it was already loaded
Jan 04 11:09:02 dev sessionclean[20429]: Cannot load Xdebug - it was already loaded
Jan 04 11:09:02 dev sessionclean[20429]: Cannot load Xdebug - it was already loaded
Jan 04 11:09:02 dev systemd[1]: Started Clean php session files.
-- Subject: Unit phpsessionclean.service has finished start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit phpsessionclean.service has finished starting up.
--
-- The start-up result is done.

我看不到任何mysqld.sock文件，我试图在安全模式下启动恢复选项等，但我没有成功。任何帮助都将不胜感激。

mysqlsockets

暂无答案！

目前还没有任何答案，快来回答吧！

我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com