view release on metacpan or  search on metacpan

docs/pod/INSTALL.MacOSX.pod  view on Meta::CPAN

                 uid     gid
	mysql    2001    2001

The mysql user:

   $ niutil -create / /users/mysql	
   $ niutil -createprop / /users/mysql uid 2001
   $ niutil -createprop / /users/mysql gid 2001
   $ niutil -createprop / /users/mysql name mysql
   $ niutil -createprop / /users/mysql passwd *
   $ niutil -createprop / /users/mysql realname mysql
   $ niutil -createprop / /users/mysql _writers_passwd root
   $ niutil -createprop / /users/mysql change 0
   $ niutil -createprop / /users/mysql home /usr/local/mysql
   $ niutil -createprop / /users/mysql shell /dev/null

The mysql group:

   $ niutil -create / /groups/mysql
   $ niutil -createprop / /groups/mysql gid 2001
   $ niutil -createprop / /groups/mysql passwd *

Note that the mysql user's home directory was set to
/usr/local/mysql, a directory that will be created during the
installation of MySQL.

=item 3. MySQL

MySQL can be installed on Mac OS X as a precompiled package,
compiled directly from source, or through the fink package manager
as either source or binary. Installation from a precompiled binary
is the fastest and most sure-fire way to get a working installation.
However, I've found that a source install, although a little slower,
more closely mirrors mysql installations on unix systems.

=over 4

=item Installing MySQL from source

=over 4

=item 1. Download the source tarball from mysql.com

    % curl -O ftp://ftp.orst.edu/pub/mysql/Downloads/MySQL-4.0/mysql-4.0.13.tar.gz

=item 2. Unpack and install the distribution

    % gnutar -zxf mysql-4.0.12.tar.gz
    % cd mysql-4.0.12
    % ./configure --prefix=/usr/local/mysql \
                  --with-unix-socket-path=/usr/local/mysql/run/mysql_socket \
                  --with-mysqld-user=mysql \
                  --with-comment
    % make
    % sudo make install
    % sudo mkdir /usr/local/mysql/run

=item 3. Configure the installation

    % sudo /usr/local/mysql/bin/mysql_install_db --force # create var/ for DBs
    % sudo chown -R mysql /usr/local/mysql/var /usr/local/mysql/run
    % sudo chgrp -R mysql /usr/local/mysql

=back

=item Installing MySQL from a precompiled package

=over 4

=item 1. Download the package from mysql.com

    http://www.mysql.com/downloads/

Find the "standard" release in pkg/dmg form and download it from a
nearby mirror.  Double click the .dmg file and follow the typical
installer instructions.  The package places everything in standard
paths (ie the mysql.sock is found in /etc/).

=item 2. Configure the installation

    % sudo chown -R mysql /usr/local/mysql/data
    % sudo chgrp -R mysql /usr/local/mysql
    % cd /usr/local/mysql
    % sudo ./configure # installs the appropriate databases

=back

=back

=item 4. Starting MySQL

=over 4

=item 1. Start the mysql database daemon

    % sudo /usr/local/mysql/bin/mysqld_safe --user=mysql &
         OR (for Fink installs):
    % sudo /sw/bin/mysqld_safe &

=item 2. Set a root user for the MySQL installation
   
    % mysqladmin -u root password 'new_password'

=item 3. Finally, be sure to add the mysql/bin directory to your path.

=item  4. You will also probably want to create a mysql user and group.

See the MySQL documentation for more information.  

=back

=item 5. Installing libjpeg, libpng, gd, and GD

gd is a graphics drawing library and is the most troublesome part of a
GBrowse installation.  Although GD and GD.pm can both be installed by
fink, there are path and versioning difficulties that have yet to be
worked out.  In addition to <little> gd, there is <big> GD, a perl
library for interacting with little gd.
  
Install jpegsrc and libpng

  % curl -O  ftp://ftp.uu.net/graphics/jpeg/jpegsrc.v6b.tar.gz
  % gnutar -xzf jpegsrc.v6b.tar.gz
  % pushd jpeg-6b/
  % ./configure
  % make
  % sudo make install mandir=/usr/local/share/man
  % sudo make install-lib
  % sudo ranlib /usr/local/lib/libjpeg.a
  % popd

Now you need to compile the libpng code. This allows you to
manipulate PNG files.

  % curl -O http://www.libpng.org/pub/png/src/libpng-1.2.5.tar.gz
  % gnutar -xzf libpng-1.2.5.tar.gz 
  % pushd libpng-1.2.5/
  % cp scripts/makefile.darwin makefile
  % make ZLIBINC="/usr/lib" ZLIBLIB="/usr/lib"
  % sudo make install
  % sudo ranlib /usr/local/lib/libpng.a