{"id":2995,"date":"2016-11-27T09:43:38","date_gmt":"2016-11-27T01:43:38","guid":{"rendered":"http:\/\/ixyzero.com\/blog\/?p=2995"},"modified":"2016-11-27T09:43:38","modified_gmt":"2016-11-27T01:43:38","slug":"%e5%9c%a8mac%e4%b8%8b%e5%ae%89%e8%a3%85mysql%e5%b9%b6%e8%ae%be%e7%bd%ae%e4%b8%ba%e5%bc%80%e6%9c%ba%e5%90%af%e5%8a%a8","status":"publish","type":"post","link":"https:\/\/ixyzero.com\/blog\/archives\/2995.html","title":{"rendered":"\u5728Mac\u4e0b\u5b89\u88c5MySQL\u5e76\u8bbe\u7f6e\u4e3a\u5f00\u673a\u542f\u52a8"},"content":{"rendered":"<p>=Start=<\/p>\n<h5>\u7f18\u7531\uff1a<\/h5>\n<p>\u672c\u5730\u642d\u5efa\u73af\u5883\u9700\u8981MySQL\uff0c\u4e14\u9891\u7e41\u624b\u52a8\u542f\u52a8MySQL\u4e0d\u592a\u65b9\u4fbf\uff0c\u6240\u4ee5\u5728\u6b64\u8bb0\u5f55\u4e00\u4e0b\u5b89\u88c5MySQL\u548c\u8bbe\u7f6e\u5f00\u673a\u542f\u52a8\u7684\u65b9\u6cd5\u3002<\/p>\n<h5>\u6b63\u6587\uff1a<\/h5>\n<pre class=\"lang:default decode:true \"># \u7528 Homebrew \u5b89\u88c5MySQL\nbrew search mysql\nbrew info mysql\nbrew install mysql\n\n# \u624b\u52a8\u542f\u52a8MySQL\nmysql.server start\n\n# \u4e3aMySQL\u8bbe\u7f6e\u5bc6\u7801\nmysql_secure_installation\n\n# \u767b\u5f55MySQL\nmysql -uroot -p\n\n# \u5c06MySQL\u8bbe\u7f6e\u4e3a\u5f00\u673a\u542f\u52a8\nbrew services start mysql\n# brew \u5728\u5b89\u88c5\u7684\u65f6\u5019\u5df2\u7ecf\u4e3a\u4f60\u5199\u597d\u4e86 .plist \u6587\u4ef6\u3002\u4f60\u53ea\u9700\u8981\u8fd0\u884c `brew info mysql` \u6765\u67e5\u770b\u5e2e\u52a9\u4fe1\u606f\u5373\u53ef\uff08\u540c\u6837\u9002\u7528\u4e8e redis\/postgresql\/mongo \u7b49\uff09\u3002<\/pre>\n<p>\u67e5\u770b\u4e00\u4e0b brew \u63d0\u4f9b\u7684 .plist \u6587\u4ef6\uff1a<\/p>\n<pre class=\"lang:default decode:true\"># \u5217\u51fa\u6240\u6709 brew \u63d0\u4f9b\u7684 .plist\u6587\u4ef6 \u53ca\u5176\u5bf9\u5e94\u7684\u670d\u52a1\nbrew services list\n\n# \u6e05\u9664\u6240\u6709\u4e0d\u7528\u7684\u670d\u52a1\nbrew services cleanup\n\n# \u542f\u52a8\/\u91cd\u542f \u67d0\u4e2a\u670d\u52a1\nbrew services start\/restart formula<\/pre>\n<p>\u4e0b\u9762\u4ee5brew\u63d0\u4f9b\u7684mysql.plist\u6587\u4ef6\u4e3a\u4f8b\u5b66\u4e60\u4e00\u4e0b\u300c.plist\u6587\u4ef6\u300d\u7684\u7f16\u5199\u65b9\u6cd5\uff1a<\/p>\n<pre class=\"lang:default decode:true\">$ cat ~\/Library\/LaunchAgents\/homebrew.mxcl.mysql.plist\n&lt;?xml version=\"1.0\" encoding=\"UTF-8\"?&gt;\n&lt;!DOCTYPE plist PUBLIC \"-\/\/Apple\/\/DTD PLIST 1.0\/\/EN\" \"http:\/\/www.apple.com\/DTDs\/PropertyList-1.0.dtd\"&gt;\n&lt;plist version=\"1.0\"&gt;\n&lt;dict&gt;\n  &lt;key&gt;KeepAlive&lt;\/key&gt; \/\/\u8fd9\u4e2akey\u8868\u660e\u4f60\u7684daemon\u662f\u6309\u9700\u542f\u52a8\u8fd8\u662f\u9700\u8981\u4e00\u76f4\u8fd0\u884c\n  &lt;true\/&gt;\n  &lt;key&gt;Label&lt;\/key&gt; \/\/\u5fc5\u987b\u8981\u6709\u7684key\uff0c\u4e0b\u9762\u7684&lt;string&gt;\u4e3akey\u5bf9\u5e94\u7684\u503c\uff0c\u9700\u8981\u662f\u552f\u4e00\u53ef\u8fa8\u8bc6\u7684\n  &lt;string&gt;homebrew.mxcl.mysql&lt;\/string&gt;\n  &lt;key&gt;ProgramArguments&lt;\/key&gt; \/\/\u5fc5\u987b\u8981\u6709\u7684key\uff0c\u4e0b\u9762\u7684&lt;array&gt;\u4e3a\u547d\u4ee4\u7684\u8def\u5f84\u548c\u542f\u52a8\u6240\u9700\u8981\u7684\u9009\u9879\n  &lt;array&gt;\n    &lt;string&gt;\/usr\/local\/opt\/mysql\/bin\/mysqld_safe&lt;\/string&gt;\n    &lt;string&gt;--bind-address=127.0.0.1&lt;\/string&gt;\n    &lt;string&gt;--datadir=\/usr\/local\/var\/mysql&lt;\/string&gt;\n  &lt;\/array&gt;\n  &lt;key&gt;RunAtLoad&lt;\/key&gt;\n  &lt;true\/&gt;\n  &lt;key&gt;WorkingDirectory&lt;\/key&gt; \/\/\u5b98\u65b9\u6587\u6863\u63a8\u8350\u4f7f\u7528WorkingDirectory\u8fd9\u4e2akey\u6765\u6307\u5b9a\u5de5\u4f5c\u76ee\u5f55\n  &lt;string&gt;\/usr\/local\/var\/mysql&lt;\/string&gt;\n&lt;\/dict&gt;\n&lt;\/plist&gt;<\/pre>\n<p>\u624b\u52a8\u52a0\u8f7d\u67d0\u4e2a .plist \u6587\u4ef6\uff1a<\/p>\n<pre class=\"lang:default decode:true\">launchctl load -w ~\/Library\/LaunchAgents\/homebrew.mxcl.mysql.plist<\/pre>\n<p>\u68c0\u67e5\u67d0\u4e2a .plist \u6587\u4ef6\u7684\u8bed\u6cd5\/\u683c\u5f0f\u662f\u5426\u6b63\u786e\uff1a<\/p>\n<pre class=\"lang:default decode:true\">sudo plutil -lint ~\/Library\/LaunchAgents\/homebrew.mxcl.mysql.plist<\/pre>\n<h5>\u53c2\u8003\u94fe\u63a5\uff1a<\/h5>\n<ul>\n<li><a href=\"http:\/\/www.mednoter.com\/launchd.html\">http:\/\/www.mednoter.com\/launchd.html<\/a><\/li>\n<li><a href=\"http:\/\/www.jianshu.com\/p\/e73978416920\">http:\/\/www.jianshu.com\/p\/e73978416920<\/a><\/li>\n<li><a href=\"http:\/\/squll369.iteye.com\/blog\/1965185\">http:\/\/squll369.iteye.com\/blog\/1965185<\/a><\/li>\n<li><a href=\"http:\/\/developer.apple.com\/documentation\/MacOSX\/Conceptual\/BPSystemStartup\/index.html\">http:\/\/developer.apple.com\/documentation\/MacOSX\/Conceptual\/BPSystemStartup\/index.html<\/a><\/li>\n<li><a href=\"https:\/\/developer.apple.com\/library\/content\/documentation\/MacOSX\/Conceptual\/BPSystemStartup\/Chapters\/Introduction.html\">https:\/\/developer.apple.com\/library\/content\/documentation\/MacOSX\/Conceptual\/BPSystemStartup\/Chapters\/Introduction.html<\/a><\/li>\n<li><a href=\"https:\/\/developer.apple.com\/library\/content\/documentation\/MacOSX\/Conceptual\/BPSystemStartup\/Chapters\/CreatingLaunchdJobs.html#\/\/apple_ref\/doc\/uid\/10000172i-SW7-BCIEDDBJ\">https:\/\/developer.apple.com\/library\/content\/documentation\/MacOSX\/Conceptual\/BPSystemStartup\/Chapters\/CreatingLaunchdJobs.html#\/\/apple_ref\/doc\/uid\/10000172i-SW7-BCIEDDBJ<\/a><\/li>\n<li>$ man launchd<\/li>\n<\/ul>\n<p>=END=<\/p>\n","protected":false},"excerpt":{"rendered":"<p>=Start= \u7f18\u7531\uff1a \u672c\u5730\u642d\u5efa\u73af\u5883\u9700\u8981MySQL\uff0c\u4e14\u9891\u7e41\u624b\u52a8\u542f\u52a8MySQL\u4e0d\u592a\u65b9\u4fbf\uff0c\u6240\u4ee5\u5728\u6b64\u8bb0\u5f55\u4e00\u4e0b\u5b89\u88c5My [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,560,7],"tags":[683,684,559,685],"class_list":["post-2995","post","type-post","status-publish","format-standard","hentry","category-knowledgebase-2","category-mac","category-programing","tag-brew","tag-launchctl","tag-mac","tag-plist"],"views":5780,"_links":{"self":[{"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/posts\/2995","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/comments?post=2995"}],"version-history":[{"count":0,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/posts\/2995\/revisions"}],"wp:attachment":[{"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/media?parent=2995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/categories?post=2995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ixyzero.com\/blog\/wp-json\/wp\/v2\/tags?post=2995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}