{"id":130,"date":"2018-05-26T10:38:15","date_gmt":"2018-05-26T02:38:15","guid":{"rendered":"http:\/\/chenhaitao.me\/?p=130"},"modified":"2018-05-26T10:38:15","modified_gmt":"2018-05-26T02:38:15","slug":"installing-mariadb-server-on-macos-using-homebrew","status":"publish","type":"post","link":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/2018\/05\/26\/installing-mariadb-server-on-macos-using-homebrew\/","title":{"rendered":"Installing MariaDB Server on macOS Using Homebrew"},"content":{"rendered":"<p>MariaDB Server is available for installation on macOS (formerly Mac OS X) via the <a href=\"http:\/\/brew.sh\/\">Homebrew<\/a> package manager.<\/p>\n<p>MariaDB Server is available as a Homebrew &#8220;bottle&#8221;, a pre-compiled package. This means you can install it without having to build from source yourself. This saves time.<\/p>\n<p>After installing Homebrew, MariaDB Server can be installed with this command:<\/p>\n<pre class=\"fixed\">brew install mariadb\r\n<\/pre>\n<p>After installation, start MariaDB Server:<\/p>\n<pre class=\"fixed\">mysql.server start\r\n<\/pre>\n<p>To auto-start MariaDB Server, use Homebrew&#8217;s services functionality, which integrates with macOS launchctl:<\/p>\n<pre class=\"fixed\">brew services start mariadb\r\n<\/pre>\n<p>After MariaDB Server is started, you can log in:<\/p>\n<pre class=\"fixed\">mysql -u root\r\n<\/pre>\n<h2 id=\"upgrading-mariadb\" class=\"anchored_heading\">Upgrading MariaDB<\/h2>\n<p>First you may need to update your brew installation:<\/p>\n<pre class=\"fixed\">brew update\r\n<\/pre>\n<p>Then, to upgrade MariaDB Server:<\/p>\n<pre class=\"fixed\">brew upgrade mariadb\r\n<\/pre>\n<h2 id=\"building-mariadb-server-from-source\" class=\"anchored_heading\">Building MariaDB Server from source<\/h2>\n<p>In addition to the &#8220;bottled&#8221; MariaDB Server package available from Homebrew, you can use Homebrew to build MariaDB from source. This is useful if you want to use a different version of the server or enable some different capabilities that are not included in the bottle package.<\/p>\n<p>Two components not included in the bottle package (as of MariaDB Server 10.1.19) are the CONNECT and OQGRAPH engines, because they have non-standard dependencies. To build MariaDB Server with these engines, you must first install <code>boost<\/code> and <code>judy<\/code>. As of December 2016, judy is in the Homebrew &#8220;boneyard&#8221;, but the old formula still works on macOS Sierra. Follow these steps to install the dependencies and build the server:<\/p>\n<pre class=\"fixed\">brew install boost homebrew\/boneyard\/judy\r\nbrew install mariadb --build-from-source\r\n<\/pre>\n<p>You can also use Homebrew to build and install a pre-release version of MariaDB Server (for example MariaDB Server 10.2, when the highest GA version is MariaDB Server 10.1). Use this command to build and install a &#8220;development&#8221; version of MariaDB Server:<\/p>\n<pre class=\"fixed\">brew install mariadb --devel\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB Server is available for installation on macOS (formerly Mac OS X) via th&#8230;<\/p>\n<p class=\"read-more\"><a class=\"btn btn-default\" href=\"https:\/\/chenhaitao.com\/.wp-toolkit_I\/2018\/05\/26\/installing-mariadb-server-on-macos-using-homebrew\/\"> Read More<span class=\"screen-reader-text\">  Read More<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[30],"tags":[42],"class_list":["post-130","post","type-post","status-publish","format-standard","hentry","category-30","tag-installing-mariadb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9HWWB-26","jetpack-related-posts":[{"id":128,"url":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/2018\/05\/26\/mariadb%e4%bf%ae%e6%94%b9root%e5%af%86%e7%a0%81\/","url_meta":{"origin":130,"position":0},"title":"Mariadb\u4fee\u6539root\u5bc6\u7801","author":"\u6770\u514b\u9648","date":"2018\u5e745\u670826\u65e5","format":false,"excerpt":"\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u65b0\u5b89\u88c5\u7684 mariadb \u7684\u5bc6\u7801\u4e3a\u7a7a\uff0c\u5728shell\u7ec8\u7aef\u76f4\u63a5\u8f93\u5165 mysql \u5c31\u80fd\u767b\u9646\u6570\u636e\u2026","rel":"","context":"\u5728\u201c\u5f00\u53d1\u201d\u4e2d","block_context":{"text":"\u5f00\u53d1","link":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/category\/%e5%bc%80%e5%8f%91\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":117,"url":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/2018\/05\/08\/mac%e4%bd%bf%e7%94%a8%e7%bb%88%e7%ab%af%e5%ae%89%e8%a3%85homebrewbrew\/","url_meta":{"origin":130,"position":1},"title":"Mac\u4f7f\u7528\u7ec8\u7aef\u5b89\u88c5Homebrew(brew)","author":"\u6770\u514b\u9648","date":"2018\u5e745\u67088\u65e5","format":false,"excerpt":"Homebrew\u7b80\u79f0brew,OSX\u4e0a\u7684\u8f6f\u4ef6\u5305\u7ba1\u7406\u5de5\u5177\uff0c\u5728Mac\u7ec8\u7aef\u53ef\u4ee5\u901a\u8fc7brew\u5b89\u88c5\u3001\u66f4\u65b0\u3001\u5378\u8f7d\u2026","rel":"","context":"\u5728\u201c\u5f00\u53d1\u201d\u4e2d","block_context":{"text":"\u5f00\u53d1","link":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/category\/%e5%bc%80%e5%8f%91\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":71,"url":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/2018\/04\/04\/centos7%e4%b8%8brabbitmq%e6%9c%8d%e5%8a%a1%e5%ae%89%e8%a3%85%e9%85%8d%e7%bd%ae\/","url_meta":{"origin":130,"position":2},"title":"CentOS7\u4e0bRabbitMQ\u670d\u52a1\u5b89\u88c5\u914d\u7f6e","author":"\u6770\u514b\u9648","date":"2018\u5e744\u67084\u65e5","format":false,"excerpt":"RabbitMQ\u662f\u6d41\u884c\u7684\u5f00\u6e90\u6d88\u606f\u961f\u5217\u7cfb\u7edf\uff0c\u662fAMQP\uff08Advanced Message Queuin\u2026","rel":"","context":"\u5728\u201c\u8fd0\u7ef4\u201d\u4e2d","block_context":{"text":"\u8fd0\u7ef4","link":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/category\/%e8%bf%90%e7%bb%b4\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":113,"url":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/2018\/05\/06\/outlook-for-mac%e8%87%aa%e5%8a%a8%e5%bd%92%e6%a1%a3%e8%ae%be%e7%bd%ae\/","url_meta":{"origin":130,"position":3},"title":"outlook for mac\u81ea\u52a8\u5f52\u6863\u8bbe\u7f6e","author":"\u6770\u514b\u9648","date":"2018\u5e745\u67086\u65e5","format":false,"excerpt":"In Outlook, click on a message or range of message\u2026","rel":"","context":"\u5728\u201c\u5e94\u7528\u201d\u4e2d","block_context":{"text":"\u5e94\u7528","link":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/category\/%e5%ba%94%e7%94%a8\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":119,"url":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/2018\/05\/08\/%e5%ae%89%e8%a3%85-git\/","url_meta":{"origin":130,"position":4},"title":"\u5b89\u88c5 Git","author":"\u6770\u514b\u9648","date":"2018\u5e745\u67088\u65e5","format":false,"excerpt":"\u662f\u65f6\u5019\u52a8\u624b\u5c1d\u8bd5\u4e0b Git \u4e86\uff0c\u4e0d\u8fc7\u5f97\u5148\u5b89\u88c5\u597d\u5b83\u3002\u6709\u8bb8\u591a\u79cd\u5b89\u88c5\u65b9\u5f0f\uff0c\u4e3b\u8981\u5206\u4e3a\u4e24\u79cd\uff0c\u4e00\u79cd\u662f\u901a\u8fc7\u7f16\u8bd1\u6e90\u4ee3\u7801\u2026","rel":"","context":"\u5728\u201c\u5f00\u53d1\u201d\u4e2d","block_context":{"text":"\u5f00\u53d1","link":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/category\/%e5%bc%80%e5%8f%91\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":132,"url":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/2018\/05\/26\/mac%e7%b3%bb%e7%bb%9f%e5%ae%89%e8%a3%85redis\/","url_meta":{"origin":130,"position":5},"title":"mac\u7cfb\u7edf\u5b89\u88c5redis","author":"\u6770\u514b\u9648","date":"2018\u5e745\u670826\u65e5","format":false,"excerpt":"1.\u4e0b\u8f7d \u6253\u5f00\u5b98\u7f51\uff1ahttps:\/\/redis.io\/ Download---Stable---Do\u2026","rel":"","context":"\u5728\u201c\u5f00\u53d1\u201d\u4e2d","block_context":{"text":"\u5f00\u53d1","link":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/category\/%e5%bc%80%e5%8f%91\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/wp-json\/wp\/v2\/posts\/130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/wp-json\/wp\/v2\/comments?post=130"}],"version-history":[{"count":1,"href":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/wp-json\/wp\/v2\/posts\/130\/revisions"}],"predecessor-version":[{"id":131,"href":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/wp-json\/wp\/v2\/posts\/130\/revisions\/131"}],"wp:attachment":[{"href":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/wp-json\/wp\/v2\/media?parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/wp-json\/wp\/v2\/categories?post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chenhaitao.com\/.wp-toolkit_I\/wp-json\/wp\/v2\/tags?post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}