{"id":264,"date":"2012-12-05T11:56:58","date_gmt":"2012-12-05T11:56:58","guid":{"rendered":"https:\/\/shan.info\/new\/%e9%87%8d%e5%90%afmysql%e7%9a%84%e6%ad%a3%e7%a1%ae%e6%96%b9%e6%b3%95\/"},"modified":"2012-12-05T11:56:58","modified_gmt":"2012-12-05T11:56:58","slug":"%e9%87%8d%e5%90%afmysql%e7%9a%84%e6%ad%a3%e7%a1%ae%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/shan.info\/new\/%e9%87%8d%e5%90%afmysql%e7%9a%84%e6%ad%a3%e7%a1%ae%e6%96%b9%e6%b3%95\/","title":{"rendered":"\u91cd\u542fMySQL\u7684\u6b63\u786e\u65b9\u6cd5"},"content":{"rendered":"<p><span style=\"color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\">\u5982\u679c\u4f60\u662f\u4ece\u6e90\u7801\u5305\u5b89\u88c5\u7684Mysql\uff0c\u90a3\u4e48\u7cfb\u7edf\u4e2d\u662f\u6ca1\u6709\u7ea2\u5e3d\u5e38\u7528\u7684servcie\u8fd9\u4e2a\u811a\u672c\u7684\uff0c<\/span><br style=\"padding: 0px; margin: 0px; color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\" \/> <br style=\"padding: 0px; margin: 0px; color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\" \/> <span style=\"color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\">\u6240\u4ee5\u53ea\u597d\u624b\u5de5\u91cd\u542f<\/span><br style=\"padding: 0px; margin: 0px; color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\" \/> <br style=\"padding: 0px; margin: 0px; color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\" \/> <span style=\"color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\">\u6709\u4eba\u5efa\u8baeKillall mysql\u3002\u8fd9\u79cd\u91ce\u86ee\u7684\u65b9\u6cd5\u5176\u5b9e\u662f\u4e0d\u884c\u7684\uff0c\u5f3a\u5236\u7ec8\u6b62\u7684\u8bdd\uff0c\u53ef\u80fd\u4f1a\u9020\u6210\u8868\u635f\u574f\uff0c\u635f\u5931\u662f\u5de8\u5927\u7684\u3002<\/span><br style=\"padding: 0px; margin: 0px; color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\" \/> <br style=\"padding: 0px; margin: 0px; color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\" \/> <span style=\"color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\">\u8fd9\u91cc\u63a8\u8350\u5b89\u5168\u7684\u91cd\u542f\u65b9\u6cd5<\/span><br style=\"padding: 0px; margin: 0px; color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\" \/> <br style=\"padding: 0px; margin: 0px; color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\" \/> <span style=\"color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\">$mysql_dir\/bin\/mysqladmin -u root -p shutdown<\/span><br style=\"padding: 0px; margin: 0px; color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\" \/> <span style=\"color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\">$mysql_dir\/bin\/safe_mysqld &amp;\u00a0<\/span><br style=\"padding: 0px; margin: 0px; color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\" \/> <br style=\"padding: 0px; margin: 0px; color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\" \/> <span style=\"color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\">mysqladmin\u548cmysqld_safe\u4f4d\u4e8eMysql\u5b89\u88c5\u76ee\u5f55\u7684bin\u76ee\u5f55\u4e0b\uff0c\u5f88\u5bb9\u6613\u627e\u5230\u7684\u3002<\/span><\/p>\n<p><span style=\"color: #222222; font-family: arial, sans-serif; font-size: small; line-height: 16px;\">\/usr\/<\/span><em style=\"color: #dd4b39; font-style: normal; font-family: arial, sans-serif; font-size: small; line-height: 16px;\">bin\/<\/em><span style=\"color: #555555; font-family: \u5b8b\u4f53, 'Arial Narrow', arial, serif; font-size: 14px; line-height: 28px;\">mysqladmin -u root -p shutdown<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5982\u679c\u4f60\u662f\u4ece\u6e90\u7801\u5305\u5b89\u88c5\u7684Mysql\uff0c\u90a3\u4e48\u7cfb\u7edf\u4e2d\u662f\u6ca1\u6709\u7ea2\u5e3d\u5e38\u7528\u7684servcie\u8fd9\u4e2a\u811a\u672c\u7684\uff0c \u6240\u4ee5\u53ea\u597d\u624b\u5de5\u91cd\u542f \u6709\u4eba\u5efa\u8baeKillall mysql\u3002\u8fd9\u79cd\u91ce\u86ee\u7684\u65b9\u6cd5\u5176\u5b9e\u662f\u4e0d\u884c\u7684\uff0c\u5f3a\u5236\u7ec8\u6b62\u7684\u8bdd\uff0c\u53ef\u80fd\u4f1a\u9020\u6210\u8868\u635f\u574f\uff0c\u635f\u5931\u662f\u5de8\u5927\u7684\u3002 \u8fd9\u91cc\u63a8\u8350\u5b89\u5168\u7684\u91cd\u542f\u65b9\u6cd5 $mysql_dir\/bin\/mysqladmin -u root -p shutdown $mysql_dir\/bin\/safe_mysqld &amp;\u00a0 mysqladmin\u548cmysqld_safe\u4f4d\u4e8eMysql\u5b89\u88c5\u76ee\u5f55\u7684bin\u76ee\u5f55\u4e0b\uff0c\u5f88\u5bb9\u6613\u627e\u5230\u7684\u3002 \/usr\/bin\/mysqladmin -u root -p shutdown<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46],"tags":[],"class_list":["post-264","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts\/264","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/comments?post=264"}],"version-history":[{"count":0,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts\/264\/revisions"}],"wp:attachment":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/media?parent=264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/categories?post=264"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/tags?post=264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}