{"id":859,"date":"2021-09-02T02:49:00","date_gmt":"2021-09-01T18:49:00","guid":{"rendered":"http:\/\/www.langmanezhuang.com\/index.php\/2021\/09\/02\/linux%e5%90%af%e5%8a%a8-%e5%81%9c%e6%ad%a2-%e9%87%8d%e5%90%afmysql%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e6%96%b9%e6%b3%95\/"},"modified":"2021-09-02T02:49:00","modified_gmt":"2021-09-01T18:49:00","slug":"linux%e5%90%af%e5%8a%a8-%e5%81%9c%e6%ad%a2-%e9%87%8d%e5%90%afmysql%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"http:\/\/blog.langmanezhuang.com\/index.php\/2021\/09\/02\/linux%e5%90%af%e5%8a%a8-%e5%81%9c%e6%ad%a2-%e9%87%8d%e5%90%afmysql%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e6%96%b9%e6%b3%95\/","title":{"rendered":"Linux\u542f\u52a8\/\u505c\u6b62\/\u91cd\u542fMysql\u6570\u636e\u5e93\u7684\u65b9\u6cd5"},"content":{"rendered":"<div class=\"cnblogs_code\">\n<pre><span style=\"color: #800080;\">1<\/span><span style=\"color: #000000;\">\u3001\u67e5\u770bmysql\u7248\u672c\n\u65b9\u6cd5\u4e00\uff1astatus;\n\u65b9\u6cd5\u4e8c\uff1a<\/span><span style=\"color: #0000ff;\">select<\/span><span style=\"color: #000000;\"> version();\n\n<\/span><span style=\"color: #800080;\">2<\/span><span style=\"color: #000000;\">\u3001Mysql\u542f\u52a8\u3001\u505c\u6b62\u3001\u91cd\u542f\u5e38\u7528\u547d\u4ee4\na\u3001\u542f\u52a8\u65b9\u5f0f\n<\/span><span style=\"color: #800080;\">1<\/span><span style=\"color: #000000;\">\u3001\u4f7f\u7528 service \u542f\u52a8\uff1a\n[root@localhost <\/span>\/]# service mysqld start (<span style=\"color: #800080;\">5<\/span><span style=\"color: #000000;\">.0\u7248\u672c\u662fmysqld)\n[root@szxdb etc]# service mysql start (<\/span><span style=\"color: #800080;\">5.5<\/span><span style=\"color: #000000;\">.7\u7248\u672c\u662fmysql)\n\n<\/span><span style=\"color: #800080;\">2<\/span><span style=\"color: #000000;\">\u3001\u4f7f\u7528 mysqld \u811a\u672c\u542f\u52a8\uff1a\n<\/span>\/etc\/inint.d\/<span style=\"color: #000000;\">mysqld start\n\n<\/span><span style=\"color: #800080;\">3<\/span><span style=\"color: #000000;\">\u3001\u4f7f\u7528 safe_mysqld \u542f\u52a8\uff1a\nsafe_mysqld<\/span>&amp;<span style=\"color: #000000;\">\n\nb\u3001\u505c\u6b62\n<\/span><span style=\"color: #800080;\">1<\/span><span style=\"color: #000000;\">\u3001\u4f7f\u7528 service \u542f\u52a8\uff1a\nservice mysqld stop\n\n<\/span><span style=\"color: #800080;\">2<\/span><span style=\"color: #000000;\">\u3001\u4f7f\u7528 mysqld \u811a\u672c\u542f\u52a8\uff1a\n<\/span>\/etc\/inint.d\/<span style=\"color: #000000;\">mysqld stop\n\n<\/span><span style=\"color: #800080;\">3<\/span><span style=\"color: #000000;\">\u3001mysqladmin shutdown\n\nc\u3001\u91cd\u542f\n<\/span><span style=\"color: #800080;\">1<\/span><span style=\"color: #000000;\">\u3001\u4f7f\u7528 service \u542f\u52a8\uff1a\nservice mysqld restart\nservice mysql restart (<\/span><span style=\"color: #800080;\">5.5<\/span><span style=\"color: #000000;\">.7\u7248\u672c\u547d\u4ee4)\n\n<\/span><span style=\"color: #800080;\">2<\/span><span style=\"color: #000000;\">\u3001\u4f7f\u7528 mysqld \u811a\u672c\u542f\u52a8\uff1a\n<\/span>\/etc\/init.d\/mysqld restart<\/pre>\n<\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1\u3001\u67e5\u770bmysql\u7248\u672c \u65b9\u6cd5\u4e00\uff1astatus; \u65b9\u6cd5\u4e8c\uff1aselect version(); 2\u3001Mysql\u542f\u52a8 &hellip; <a href=\"http:\/\/blog.langmanezhuang.com\/index.php\/2021\/09\/02\/linux%e5%90%af%e5%8a%a8-%e5%81%9c%e6%ad%a2-%e9%87%8d%e5%90%afmysql%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e6%96%b9%e6%b3%95\/\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">Linux\u542f\u52a8\/\u505c\u6b62\/\u91cd\u542fMysql\u6570\u636e\u5e93\u7684\u65b9\u6cd5<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts\/859"}],"collection":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/comments?post=859"}],"version-history":[{"count":0,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/posts\/859\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/media?parent=859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/categories?post=859"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.langmanezhuang.com\/index.php\/wp-json\/wp\/v2\/tags?post=859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}