{"id":105445,"date":"2024-09-28T18:50:29","date_gmt":"2024-09-28T10:50:29","guid":{"rendered":"https:\/\/lrxjmw.cn\/?p=105445"},"modified":"2024-09-28T18:50:29","modified_gmt":"2024-09-28T10:50:29","slug":"linux-mysql-reboot","status":"publish","type":"post","link":"https:\/\/lrxjmw.cn\/linux-mysql-reboot.html","title":{"rendered":"\u5982\u4f55\u89e3\u51b3Linux\u4e3b\u673a\u6539\u540d\u540e\u65e0\u6cd5\u542f\u52a8MySQL"},"content":{"rendered":"

MySQL\u65e0\u6cd5\u91cd\u542f\u3001\u65e0\u6cd5\u5173\u95ed\u3001\u65e0\u6cd5\u542f\u52a8\u3001\u65e0\u6cd5\u4f7f\u7528\uff0c\u5982\u679c\u662f\u56e0\u4e3a\u4fee\u6539\u4e86\u4e3b\u673a\u540d\uff0c\u53ef\u4ee5\u8fd9\u6837\u89e3\u51b3\uff1a\u5173\u95ed\u6389\u6240\u6709MySQL\u8fdb\u7a0b\uff0c\u7136\u540e\u5728\u542f\u52a8\u4e00\u4e0bMySQL\u3002<\/p>\n

\"\"<\/p>\n

\u4eca\u5929\u65e0\u4e8b\u770b\u5230\u81ea\u5df1\u7684\u4e3b\u673a\u540d\u4e0d\u5bf9\uff0c\u4e8e\u662f\u6539\u4e86\u4e00\u4e0b\uff0c\u4ee5\u4fbf\u533a\u5206\u670d\u52a1\u5668\uff0c\u7ed3\u679c\u91cd\u542fmysql\u65f6\u51fa\u73b0\u4e0b\u9762\u9519\u8bef\uff1a<\/p>\n

MySQL manager or server PID file could not be found!\u00a0 \u00a0 \u00a0 [FAILED]\r\nStarting MySQL.Manager of pid-file quit without updating fi[FAILED]<\/pre>\n
\u600e\u4e48\u4f1a\u627e\u4e0d\u5230PID\u5462\uff0c\u770b\u4e0b\u9762\uff1a<\/p>\n
[root@linuxidc.com ~]#\u00a0 ps aux | grep mysql\r\nmysql\u00a0 \u00a0 16433\u00a0 0.0\u00a0 0.2\u00a0 36636\u00a0 5756 ?\u00a0 \u00a0 \u00a0 \u00a0 Sl\u00a0 15:07\u00a0 0:00 \/usr\/local\/mysql\/libexec\/mysqld --basedir=\/usr\/local\/mysql --datadir=\/usr\/local\/mysql\/var --user=mysql --log-error=\/usr\/local\/mysql\/var\/hao9goAndSecondWeb.err --pid-file=\/usr\/local\/mysql\/var\/hao9goAndSecondWeb.pid --socket=\/tmp\/mysql.sock --port=3306\r\nroot\u00a0 \u00a0 16992\u00a0 0.0\u00a0 0.0\u00a0 4020\u00a0 704 pts\/0\u00a0 \u00a0 S+\u00a0 15:11\u00a0 0:00 grep mysql<\/pre>\n
\u539f\u6765PID\u8fd8\u662f\u539f\u6765\u4e3b\u673a\u540d.pid\uff0c\u8fd0\u884c:<\/p>\n
kill -9 <mysqlpid> \u7136\u540e service mysql start \u54c8\u54c8\u770b\u5230\u7eff\u8272\u7684OK\u4e86\uff0c\r\n\r\n[root@linuxidc ~]# service mysql start\r\nStarting MySQL.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 [\u00a0OK\u00a0 ]<\/pre>\n
\n
\u539f\u6587\u6765\u81ea\uff1ahttp:\/\/www.linuxsir.org\/linuxsjk\/14257.html<\/a><\/p>\n
\u672c\u6587\u5730\u5740\uff1ahttps:\/\/lrxjmw.cn\/linux-mysql-reboot.html<\/a>\u7f16\u8f91\uff1a\u8d3e\u6625\u534e \u00a0\u5ba1\u6838\u5458\uff1a\u9004\u589e\u5b9d<\/span><\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"
MySQL\u65e0\u6cd5\u91cd\u542f\u3001\u65e0\u6cd5\u5173\u95ed\u3001\u65e0\u6cd5\u542f\u52a8\u3001\u65e0\u6cd5\u4f7f\u7528\uff0c\u5982\u679c\u662f\u56e0\u4e3a\u4fee\u6539\u4e86\u4e3b\u673a\u540d\uff0c\u53ef\u4ee5\u8fd9\u6837\u89e3\u51b3\uff1a\u5173\u95ed\u6389\u6240\u6709MySQL\u8fdb […]<\/p>\n","protected":false},"author":63,"featured_media":105241,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[55],"tags":[],"class_list":["post-105445","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thread"],"acf":[],"_links":{"self":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/105445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/users\/63"}],"replies":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/comments?post=105445"}],"version-history":[{"count":8,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/105445\/revisions"}],"predecessor-version":[{"id":105801,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/105445\/revisions\/105801"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/media\/105241"}],"wp:attachment":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/media?parent=105445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/categories?post=105445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/tags?post=105445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}