{"id":25,"date":"2020-12-28T19:04:39","date_gmt":"2020-12-28T11:04:39","guid":{"rendered":"https:\/\/www.52dixiaowo.com\/database\/?p=25"},"modified":"2020-12-28T19:04:40","modified_gmt":"2020-12-28T11:04:40","slug":"mysql-%e7%9a%84%e5%8d%b8%e8%bd%bd","status":"publish","type":"post","link":"https:\/\/www.52dixiaowo.com\/db\/post-25.html","title":{"rendered":"mysql \u7684\u5378\u8f7d"},"content":{"rendered":"\n<p>\u5982\u679c\u4e0d\u518d\u9700\u8981 mysql \u6216\u5b89\u88c5\u5931\u8d25\uff0c\u5219\u9700\u8981\u5378\u8f7d mysql<\/p>\n\n\n\n<p>\uff08\u4ec5\u9488\u5bf9\u5b89\u88c5\u7248\uff0c\u89e3\u538b\u7248\u7684\u76f4\u63a5\u5220\u9664\u6574\u4e2a\u76ee\u5f55\u5373\u53ef\uff09<\/p>\n\n\n\n<h5>\u5982\u4f55\u5e72\u51c0\u7684\u5378\u8f7d mysql ?<\/h5>\n\n\n\n<p>1.\u627e\u5230 mysql \u7684\u5b89\u88c5\u76ee\u5f55\u4e0b\u7684 my.ini\uff0c\u5728\u6b64\u6587\u4ef6\u4e2d\u627e\u5230 datadir \uff0c\u8bb0\u5f55\u8fd9\u4e2a\u503c<\/p>\n\n\n\n<p>\uff08 \u5982\u679c mysql \u7248\u672c\u8f83\u9ad8\uff0c\u9ed8\u8ba4 my.ini \u548c datadir \u540c\u4e00\u4e2a\u76ee\u5f55\uff0c\u5728\u5982\u4e0b\u8def\u5f84\uff09<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>C:\\ProgramData\\MySQL<\/code><\/pre>\n\n\n\n<p>2.\u5728\u63a7\u5236\u9762\u677f\u627e\u5230 mysql \uff0c\u7136\u540e\u5378\u8f7d<\/p>\n\n\n\n<p>3.\u628a\u521a\u624d my.ini \u8bb0\u5f55\u7684 datadir \u503c\uff0c\u76f4\u63a5\u4f7f\u7528\u8d44\u6e90\u7ba1\u7406\u5668\u8fdb\u5165\u8be5\u76ee\u5f55<\/p>\n\n\n\n<p>\uff08\u8fd9\u4e2a\u76ee\u5f55\u4e00\u822c\u662f\u9690\u85cf\u76ee\u5f55\uff0c\u76f4\u63a5\u8f93\u5165\uff0c\u6216\u8bbe\u7f6e\u663e\u793a\u9690\u85cf\u76ee\u5f55\uff0c\u5c31\u53ef\u8fdb\u5165\uff09<\/p>\n\n\n\n<p>4.\u628a datadir \u76ee\u5f55\u4e0b\u7684 mysql \u76ee\u5f55\u5168\u90e8\u5220\u6389\uff0c\u8fd9\u91cc\u5305\u542b\u4e86 mysql \u7684\u914d\u7f6e\u4fe1\u606f<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5982\u679c\u4e0d\u518d\u9700\u8981 mysql \u6216\u5b89\u88c5\u5931\u8d25\uff0c\u5219\u9700\u8981\u5378\u8f7d mysql \uff08\u4ec5\u9488\u5bf9\u5b89\u88c5\u7248\uff0c\u89e3\u538b\u7248\u7684\u76f4\u63a5\u5220\u9664\u6574\u4e2a\u76ee\u5f55\u5373\u53ef\uff09 &hellip; <a href=\"https:\/\/www.52dixiaowo.com\/db\/post-25.html\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">mysql \u7684\u5378\u8f7d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts\/25"}],"collection":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/comments?post=25"}],"version-history":[{"count":1,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts\/25\/revisions"}],"predecessor-version":[{"id":26,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts\/25\/revisions\/26"}],"wp:attachment":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/media?parent=25"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/categories?post=25"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/tags?post=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}