Upgrading to MySQL 5

February 10, 2006

http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-standard-5.0.18-osx10.4-powerpc.dmg/from/pick#mirrors

G5 version (& RAM > 4GB) http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-standard-5.0.18-osx10.4-powerpc-64bit.dmg/from/pick#mirrors

> mkdir /Library/StartupItems/MySQLCOM

> nano /Library/StartupItems/MySQLCOM/MySQLCOM



#!/bin/sh



##

# MySQL 5 Server

##



. /etc/rc.common



StartService ()

{

   if [ "${MYSQL:=-NO-}" = "-YES-" ]; then

  ConsoleMessage "Starting MySQL 5 Server"

 cd /usr/local/mysql

      ./bin/mysqld_safe &

      fi

}



StopService ()

{

   ConsoleMessage "Stopping MySQL 5 Server"

 PIDS=`ps ax | grep mysql | grep -v grep | awk '{print $1}'`

      for pid in $PIDS; do

             kill -KILL $pid

   done

}



RestartService ()

{

       StopService

      sleep 3

  StartService

}



RunService "$1"





> nano /Library/StartupItems/MySQLCOM/StartupParameters.plist

{

      Description = "MySQL 5 Server";

  Provides = ("MySQLCOM");

 Requires = ("Resolver");

 OrderPreference = "Late";

        Messages =

       {

                start = "Starting MySQL 5 Server";

               stop = "Stopping MySQL 5 Server";

        };

}

Check /etc/hostconfig

MySQLCOM -=YES=-

Create DB:

>/usr/local/mysql/bin/mysqladmin -u root -p create TESTING

Add users:

GRANT ALL PRIVILEGES ON TESTING.* TO 'name'@'localhost' IDENTIFIED BY 'password';