{"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":"

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

Step 1: Check Mac Version<\/strong>
\nVery first step is to verify the Mac OS X’s current version to decide MySQL Installation file to be downloaded.
\nFor example for Mac version: 10.4 you should download “Mac OS X 10.4 (x86, 32-bit), Compressed TAR Archive (mysql-5.1.51-osx10.4-i686.tar.gz)”<\/p>\n

How to Check Mac Version:
\ncat \/System\/Library\/CoreServices\/SystemVersion.plist
\n<\/code><\/p>\n

<?xml version=\"1.0\" encoding=\"UTF-8\"?><\/code><\/p>\n

<!DOCTYPE plist PUBLIC \"-\/\/Apple Computer\/\/DTD PLIST 1.0\/\/EN\" <\/code><\/p>\n

\"http:\/\/www.apple.com\/DTDs\/PropertyList-1.0.dtd\"><\/code><\/p>\n

<\/p> <plist version=\"1.0\"> <dict><\/code><\/p>\n

<key>ProductBuildVersion<\/key>\u00a0 <string>8S2169<\/string> <\/code><\/p>\n

<key>ProductCopyright<\/key><string>1983-2007 Apple Inc.<\/string> <\/code><\/p>\n

<key>ProductName<\/key> <string>Mac OS X<\/string> <\/code><\/p>\n

<key>ProductUserVisibleVersion<\/key> <string>10.4.11<\/string> <\/code><\/p>\n

<key>ProductVersion<\/key> <string>10.4.11<\/string> <\/dict>
\n<\/code><\/p>\n

Installation Error:<\/span><\/strong><\/p>\n

dyld: unknown required load command 0x80000022<\/h2>\n

I ran in to problems while I installed MySQL for Mac OS X 10.5. Ofcourse I missed the step one and paid for it.<\/span>
\nIt’s about MySQL binary’s version difference errors: “dyld: unknown required load command 0x80000022”.<\/p>\n

Step 2: Download MySQL Installation (tar.gz) file from dev.mysql’s download section.<\/strong>
\nFor example go to: http:\/\/dev.mysql.com\/downloads\/mysql\/5.1.html<\/p>\n

Select appropriate OS & version and get the exact download link from mirror:
\n
\ncd \/usr\/local\/
\nwget http:\/\/dev.mysql.com\/get\/Downloads\/
\nMySQL-5.1\/mysql-5.1.51-osx10.4-i686.tar.gz\/from\/http:\/\/mysql.mirror.rafal.ca\/<\/code><\/p>\n

Step 3: Create MySQL User and Group.<\/strong><\/p>\n

Through command line we can use NetInfo Utility as:
\nniutil -create \/ \/groups\/mysql
\nniutil -createprop \/ \/groups\/mysql gid 401
\nniutil -create \/ \/users\/mysql
\nniutil -createprop \/ \/users\/mysql gid 401
\nniutil -createprop \/ \/users\/mysql uid 401<\/code><\/p>\n

Assign password to “mysql” user
\npasswd mysql<\/p>\n

Step: 4 Installing MySQL using Generic Binaries<\/strong>
\ncd \/usr\/local
\ntar -xzvf mysql-VERSION-OS.tar.gz
\nln -s full-path-to-mysql-VERSION-OS mysql
\ncd mysql
\nchown -R mysql .
\nchgrp -R mysql .
\nscripts\/mysql_install_db --user=mysql
\nchown -R root .
\nchown -R mysql data
\ncp \/usr\/local\/mysql\/support-files\/my-small.cnf \/etc\/my.cnf<\/code><\/p>\n

Step: 5 Start MySQL Server:<\/strong><\/p>\n

bin\/mysqld_safe –user=mysql &<\/p>\n

This finishes basic installation of MySQL on Mac OS X. Make sure you follow “best practices” or “after installation steps” as recommended.<\/p>\n

Recently I happen to install MySQL on Mac OS X (Darvin Kernel). Below are the quick 5 steps to accomplish the task.<\/p>\n

<strong>Step 1:\u00a0 Check Mac Version<\/strong>
\nVery first step is to verify the Mac OS X’s current version to decide MySQL Installation file to be downloaded.
\nFor example for Mac version: 10.4 you should download “Mac OS X 10.4 (x86, 32-bit), Compressed TAR Archive (mysql-5.1.51-osx10.4-i686.tar.gz)”<\/p>\n

How to Check Mac Version:
\n<code>cat \/System\/Library\/CoreServices\/SystemVersion.plist
\n<xmp>
\n<?xml version=”1.0″ encoding=”UTF-8″?>
\n<!DOCTYPE plist PUBLIC “-\/\/Apple Computer\/\/DTD PLIST 1.0\/\/EN” “http:\/\/www.apple.com\/DTDs\/PropertyList-1.0.dtd”>
\n<plist version=”1.0″>
\n<dict>
\n<key>ProductBuildVersion<\/key>
\n<string>8S2169<\/string>
\n<key>ProductCopyright<\/key>
\n<string>1983-2007 Apple Inc.<\/string>
\n<key>ProductName<\/key>
\n<string>Mac OS X<\/string>
\n<key>ProductUserVisibleVersion<\/key>
\n<string>10.4.11<\/string>
\n<key>ProductVersion<\/key>
\n<string>10.4.11<\/string>
\n<\/dict><\/code>
\n<\/xmp><\/p>\n

Installation Error: <h2>dyld: unknown required load command 0x80000022<h2>
\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.
\nIt’s about MySQL binary’s version difference errors: “dyld: unknown required load command 0x80000022”.<\/p>\n

<strong>Step 2: Download MySQL Installation (tar.gz) file from dev.mysql’s download section.<\/strong>
\nFor example go to: http:\/\/dev.mysql.com\/downloads\/mysql\/5.1.html<\/p>\n

Select appropriate OS & version and get the exact download link from mirror:
\n<code>
\ncd \/usr\/local\/
\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\/<\/code><\/p>\n

<strong>Step 3: Create MySQL User and Group.<\/strong><\/p>\n

Through command line we can use NetInfo Utility as:
\n<code>niutil -create \/ \/groups\/mysql
\nniutil -createprop \/ \/groups\/mysql gid 401
\nniutil -create \/ \/users\/mysql
\nniutil -createprop \/ \/users\/mysql gid 401
\nniutil -createprop \/ \/users\/mysql uid 401<\/code><\/p>\n

Assign password to “mysql” user
\npasswd mysql<\/p>\n

<strong>Step: 4\u00a0\u00a0 Installing MySQL using Generic Binaries<\/strong>
\n<code>cd \/usr\/local
\ntar -xzvf mysql-VERSION-OS.tar.gz
\nln -s full-path-to-mysql-VERSION-OS mysql
\ncd mysql
\nchown -R mysql .
\nchgrp -R mysql .
\nscripts\/mysql_install_db –user=mysql
\nchown -R root .
\nchown -R mysql data
\ncp \/usr\/local\/mysql\/support-files\/my-small.cnf \/etc\/my.cnf<\/code><\/p>\n

<strong>Step: 5\u00a0\u00a0\u00a0\u00a0 Start MySQL Server:<\/strong><\/p>\n

bin\/mysqld_safe –user=mysql &<\/p>\n

This finishes basic installation of MySQL on Mac OS X. Make sure you follow “best practices” or “after installation steps” 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…\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":["post-1112","post","type-post","status-publish","format-standard","category-mysql","category-mysql-articles","tag-darvin-kernel","tag-install-mysql-on-mac","tag-installation","tag-mac-os-x","tag-mysql"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t