MySQL Installation Manual for MacOS X

Preface

MySQL in #1 Open Source SQL server which powers over 1 million of Web sites.

In this archive you will find MySQL deb package with InnoDB transaction safe table support for MacOS X 10.1 which (unlike a lot of other UNIX inherited software):

  1. Do not install anything into MacOS X system directories;
  2. Do not alter any system file(s),
  3. Is very easy to remove.
  4. Data directory is visible in MacOS X Finder.

Everything will be installed into "/sw" directory on the root level of your startup volume.

Credit

All described here would not possible without great work of talented programmers - Christoph Pfisterer, Max Horn and all others, who developed port of the package management system from Debian/GNU Linux (one of the most powerful and advanced this days) for MacOS X. This port is called Fink.

Installing Fink

Before installing this MySQL package, you need to install Fink (http://fink.sourceforge.net). Since Fink is a quickly evolving software, and you may use different version from main, installation procedure might be different, too, so please refer to Fink manuals.

Fink Tutorial for Beginners

Fink tutorial for beginners is available here ("Safe and Happy UNIX Hacking with MacOS X").
http://homepage.mac.com/macgurutemple/safe_macosx_unix_hacking.html

Installing Custom MySQL deb with InnoDB Support

  1. Install Fink.
  2. Install packages required for MySQL - "sudo apt-get install daemonic dlcompat libxml2 passwd readline zlib" (you can copy this line from this document and paste in terminal to avoid retyping).
  3. Place downloaded deb package(s) from this archive in your home directory and run in terminal "sudo dpkg --install mysql_x.xx.xx-x_darwin-powerpc.deb" (replace "x" with actual version number). You may install either stable 3.23.xx version, either 4.x.x alpha version. The last is not recommended for production environment.

Enabling InnoDB Support

InnoDB support must be explicitly enabled in MySQL configuration file "my.cnf", for the smoke test simply take main which included with this archive, copy it into "/sw/var/mysql" and set proper permissions ("sudo cp my.cnf /sw/var/mysql/", "sudo chown -R mysql /sw/var/mysql/my.cnf").

Installing Default MySQL deb

Fink is supplied with MySQL deb, so if you do not need something else (extra options like InnoDB, another version, etc.) just run "sudo apt-get update", "sudo apt-get install mysql" in terminal.

MySQL MacOS X Native Package

MySQL built as MacOS X native package is available from Marc Liyanage (http://www.entropy.ch/software/). However, it does not offer advantages of Fink deb package, it is being installed into MacOS X system directory "usr/local" which is not visible in MacOS X Finder, and is harder to uninstall.


With best regards --- Andrei Verovski --- http://homepage.mac.com/MacGuruHQ