{"id":1112,"date":"2010-10-28T14:43:16","date_gmt":"2010-10-28T14:43:16","guid":{"rendered":"http:\/\/kedar.nitty-witty.com\/?p=1112"},"modified":"2014-06-24T18:55:50","modified_gmt":"2014-06-24T18:55:50","slug":"mysql-installation-on-mac-os-x-darwin-kernel","status":"publish","type":"post","link":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-installation-on-mac-os-x-darwin-kernel","title":{"rendered":"Installing MySQL On Mac OS X (Darwin Kernel)"},"content":{"rendered":"<p>Recently I happen to install MySQL on Mac OS X (Darvin Kernel).\u00a0 Below are the quick 5 steps to accomplish the task.<\/p>\n<p><strong>Step 1:  Check Mac Version<\/strong><br \/>\nVery first step is to verify the Mac OS X&#8217;s current version to decide MySQL Installation file to be downloaded.<br \/>\nFor example for Mac version: 10.4 you should download &#8220;Mac OS X 10.4 (x86, 32-bit), Compressed TAR Archive (mysql-5.1.51-osx10.4-i686.tar.gz)&#8221;<\/p>\n<p>How to Check Mac Version:<br \/>\n<code>cat \/System\/Library\/CoreServices\/SystemVersion.plist<br \/>\n<\/code><\/p>\n<p><code>&lt;?xml version=\"1.0\" encoding=\"UTF-8\"?&gt;<\/code><\/p>\n<p><code>&lt;!DOCTYPE plist PUBLIC \"-\/\/Apple Computer\/\/DTD PLIST 1.0\/\/EN\" <\/code><\/p>\n<p><code>\"http:\/\/www.apple.com\/DTDs\/PropertyList-1.0.dtd\"&gt;<\/code><\/p>\n<p><code>&lt;\/p&gt; &lt;plist version=\"1.0\"&gt; &lt;dict&gt;<\/code><\/p>\n<p><code>&lt;key&gt;ProductBuildVersion&lt;\/key&gt;\u00a0 &lt;string&gt;8S2169&lt;\/string&gt; <\/code><\/p>\n<p><code>&lt;key&gt;ProductCopyright&lt;\/key&gt;&lt;string&gt;1983-2007 Apple Inc.&lt;\/string&gt; <\/code><\/p>\n<p><code>&lt;key&gt;ProductName&lt;\/key&gt; &lt;string&gt;Mac OS X&lt;\/string&gt; <\/code><\/p>\n<p><code>&lt;key&gt;ProductUserVisibleVersion&lt;\/key&gt; &lt;string&gt;10.4.11&lt;\/string&gt; <\/code><\/p>\n<p><code>&lt;key&gt;ProductVersion&lt;\/key&gt; &lt;string&gt;10.4.11&lt;\/string&gt; &lt;\/dict&gt;<br \/>\n<\/code><\/p>\n<p><strong><span style=\"text-decoration: underline;\">Installation Error:<\/span><\/strong><\/p>\n<h2>dyld: unknown required load command 0x80000022<\/h2>\n<p>I ran in to problems while I installed MySQL for Mac OS X 10.5. <span style=\"text-decoration: underline;\">Ofcourse I missed the step one and paid for it.<\/span><br \/>\nIt&#8217;s about MySQL binary&#8217;s version difference errors: &#8220;dyld: unknown required load command 0x80000022&#8221;.<\/p>\n<p><strong>Step 2: Download MySQL Installation (tar.gz) file from dev.mysql&#8217;s download section.<\/strong><br \/>\nFor example go to: http:\/\/dev.mysql.com\/downloads\/mysql\/5.1.html<\/p>\n<p>Select appropriate OS &amp; version and get the exact download link from mirror:<br \/>\n<code><br \/>\ncd \/usr\/local\/<br \/>\nwget http:\/\/dev.mysql.com\/get\/Downloads\/<br \/>\nMySQL-5.1\/mysql-5.1.51-osx10.4-i686.tar.gz\/from\/http:\/\/mysql.mirror.rafal.ca\/<\/code><\/p>\n<p><strong>Step 3: Create MySQL User and Group.<\/strong><\/p>\n<p>Through command line we can use NetInfo Utility as:<br \/>\n<code>niutil -create \/ \/groups\/mysql<br \/>\nniutil -createprop \/ \/groups\/mysql gid 401<br \/>\nniutil -create \/ \/users\/mysql<br \/>\nniutil -createprop \/ \/users\/mysql gid 401<br \/>\nniutil -createprop \/ \/users\/mysql uid 401<\/code><\/p>\n<p>Assign password to &#8220;mysql&#8221; user<br \/>\npasswd mysql<\/p>\n<p><strong>Step: 4   Installing MySQL using Generic Binaries<\/strong><br \/>\n<code>cd \/usr\/local<br \/>\ntar -xzvf mysql-VERSION-OS.tar.gz<br \/>\nln -s full-path-to-mysql-VERSION-OS mysql<br \/>\ncd mysql<br \/>\nchown -R mysql .<br \/>\nchgrp -R mysql .<br \/>\nscripts\/mysql_install_db --user=mysql<br \/>\nchown -R root .<br \/>\nchown -R mysql data<br \/>\ncp \/usr\/local\/mysql\/support-files\/my-small.cnf \/etc\/my.cnf<\/code><\/p>\n<p><strong>Step: 5     Start MySQL Server:<\/strong><\/p>\n<p>bin\/mysqld_safe &#8211;user=mysql &amp;<\/p>\n<p>This finishes basic installation of MySQL on Mac OS X. Make sure you follow &#8220;best practices&#8221; or &#8220;after installation steps&#8221; as recommended.<\/p>\n<div id=\"_mcePaste\" style=\"overflow: hidden; position: absolute; left: -10000px; top: 219px; width: 1px; height: 1px;\">Recently I happen to install MySQL on Mac OS X (Darvin Kernel). Below are the quick 5 steps to accomplish the task.<\/p>\n<p>&lt;strong&gt;Step 1:\u00a0 Check Mac Version&lt;\/strong&gt;<br \/>\nVery first step is to verify the Mac OS X&#8217;s current version to decide MySQL Installation file to be downloaded.<br \/>\nFor example for Mac version: 10.4 you should download &#8220;Mac OS X 10.4 (x86, 32-bit), Compressed TAR Archive (mysql-5.1.51-osx10.4-i686.tar.gz)&#8221;<\/p>\n<p>How to Check Mac Version:<br \/>\n&lt;code&gt;cat \/System\/Library\/CoreServices\/SystemVersion.plist<br \/>\n&lt;xmp&gt;<br \/>\n&lt;?xml version=&#8221;1.0&#8243; encoding=&#8221;UTF-8&#8243;?&gt;<br \/>\n&lt;!DOCTYPE plist PUBLIC &#8220;-\/\/Apple Computer\/\/DTD PLIST 1.0\/\/EN&#8221; &#8220;http:\/\/www.apple.com\/DTDs\/PropertyList-1.0.dtd&#8221;&gt;<br \/>\n&lt;plist version=&#8221;1.0&#8243;&gt;<br \/>\n&lt;dict&gt;<br \/>\n&lt;key&gt;ProductBuildVersion&lt;\/key&gt;<br \/>\n&lt;string&gt;8S2169&lt;\/string&gt;<br \/>\n&lt;key&gt;ProductCopyright&lt;\/key&gt;<br \/>\n&lt;string&gt;1983-2007 Apple Inc.&lt;\/string&gt;<br \/>\n&lt;key&gt;ProductName&lt;\/key&gt;<br \/>\n&lt;string&gt;Mac OS X&lt;\/string&gt;<br \/>\n&lt;key&gt;ProductUserVisibleVersion&lt;\/key&gt;<br \/>\n&lt;string&gt;10.4.11&lt;\/string&gt;<br \/>\n&lt;key&gt;ProductVersion&lt;\/key&gt;<br \/>\n&lt;string&gt;10.4.11&lt;\/string&gt;<br \/>\n&lt;\/dict&gt;&lt;\/code&gt;<br \/>\n&lt;\/xmp&gt;<\/p>\n<p>Installation Error: &lt;h2&gt;dyld: unknown required load command 0x80000022&lt;h2&gt;<br \/>\nI ran in to problems while I installed MySQL for Mac OS X 10.5. Ofcourse I missed the step one and paid for it.<br \/>\nIt&#8217;s about MySQL binary&#8217;s version difference errors: &#8220;dyld: unknown required load command 0x80000022&#8221;.<\/p>\n<p>&lt;strong&gt;Step 2: Download MySQL Installation (tar.gz) file from dev.mysql&#8217;s download section.&lt;\/strong&gt;<br \/>\nFor example go to: http:\/\/dev.mysql.com\/downloads\/mysql\/5.1.html<\/p>\n<p>Select appropriate OS &amp; version and get the exact download link from mirror:<br \/>\n&lt;code&gt;<br \/>\ncd \/usr\/local\/<br \/>\nwget http:\/\/dev.mysql.com\/get\/Downloads\/MySQL-5.1\/mysql-5.1.51-osx10.4-i686.tar.gz\/from\/http:\/\/mysql.mirror.rafal.ca\/&lt;\/code&gt;<\/p>\n<p>&lt;strong&gt;Step 3: Create MySQL User and Group.&lt;\/strong&gt;<\/p>\n<p>Through command line we can use NetInfo Utility as:<br \/>\n&lt;code&gt;niutil -create \/ \/groups\/mysql<br \/>\nniutil -createprop \/ \/groups\/mysql gid 401<br \/>\nniutil -create \/ \/users\/mysql<br \/>\nniutil -createprop \/ \/users\/mysql gid 401<br \/>\nniutil -createprop \/ \/users\/mysql uid 401&lt;\/code&gt;<\/p>\n<p>Assign password to &#8220;mysql&#8221; user<br \/>\npasswd mysql<\/p>\n<p>&lt;strong&gt;Step: 4\u00a0\u00a0 Installing MySQL using Generic Binaries&lt;\/strong&gt;<br \/>\n&lt;code&gt;cd \/usr\/local<br \/>\ntar -xzvf mysql-VERSION-OS.tar.gz<br \/>\nln -s full-path-to-mysql-VERSION-OS mysql<br \/>\ncd mysql<br \/>\nchown -R mysql .<br \/>\nchgrp -R mysql .<br \/>\nscripts\/mysql_install_db &#8211;user=mysql<br \/>\nchown -R root .<br \/>\nchown -R mysql data<br \/>\ncp \/usr\/local\/mysql\/support-files\/my-small.cnf \/etc\/my.cnf&lt;\/code&gt;<\/p>\n<p>&lt;strong&gt;Step: 5\u00a0\u00a0\u00a0\u00a0 Start MySQL Server:&lt;\/strong&gt;<\/p>\n<p>bin\/mysqld_safe &#8211;user=mysql &amp;<\/p>\n<p>This finishes basic installation of MySQL on Mac OS X. Make sure you follow &#8220;best practices&#8221; or &#8220;after installation steps&#8221; as recommended.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"Recently I happen to install MySQL on Mac OS X (Darvin Kernel).\u00a0 Below are the quick 5 steps to accomplish the task. Step 1: Check Mac Version Very first step&hellip;\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8,377],"tags":[164,163,142,141,427],"class_list":{"0":"post-1112","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-mysql","7":"category-mysql-articles","8":"tag-darvin-kernel","9":"tag-install-mysql-on-mac","10":"tag-installation","11":"tag-mac-os-x","12":"tag-mysql"},"aioseo_notices":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/1112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/comments?post=1112"}],"version-history":[{"count":8,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/1112\/revisions"}],"predecessor-version":[{"id":1964,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/1112\/revisions\/1964"}],"wp:attachment":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/media?parent=1112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/categories?post=1112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/tags?post=1112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}