[primal:/usr/local/bin] jray% sudo ./mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
010614 14:50:09  /usr/local/libexec/mysqld: Shutdown Complete

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/local/bin/mysqladmin -u root -p password 'new-password'
/usr/local/bin/mysqladmin -u root -h primal -p password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr/local ; /usr/local/bin/safe_mysqld &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; run-all-tests

Please report any problems with the /usr/local/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

As the documentation says, you should reset the root password immediately using the command /usr/local/bin/mysqladmin -u root -p <password> <new-password> .

Creating a Startup Script

Mac OS X uses a special directory structure located in /Library/StartupItems or /System/Library/StartupItems to automatically start processes when the machine boots. Although some applications install these startup files in the /System path, the design of the operating system indicates that add-on software should use the /Library directory, rather than altering the main system folder.

There are three components to a Mac OS X startup script:

• A folder named after the service you are installing (such as MySQL).
• A shell script that bears the same name as the folder. This script should contain the commands needed to start the server process.
• An XML file named StartupParameters.plist that contains a description of the process. This currently isn't used by any Mac OS X admin tool, but presumably will provide an Extension Manager–type control of services in the future.

Let's take a look at what is exactly needed for Mac OS X and MySQL.

Create the folder MySQL in /Library/StartupItems. Within this folder, add a text file named MySQL containing the following shell script:

#!/bin/sh

##
# Start MySQL
##

. /etc/rc.common

if [ "${ MYSQL:=-NO-} " = "-YES-" ]; then
    ConsoleMessage "Starting MySQL"
    cd /usr/local ; /usr/local/bin/safe_mysqld &
fi

This script will check the /etc/hostconfig file for a line that reads MYSQL=-YES- and, if it exists, add start the server. Use a text editor to add this to the hostconfig file, or just type

echo "MYSQL=-YES-" >> /etc/hostconfig

Next, add the StartupParameters.plist file to the directory. The contents of this file are arbitrary—until Apple releases official specifications.

{
  Description     = "MySQL database server";
  Provides        = ("MySQL");
  Requires        = ("Resolver");
  OrderPreference = "None";
  Messages =
  {
    start = "Starting MySQL server";
    stop  = "Stopping MySQL server";
  } ;
}

After you add these files, your Mac OS X machine will automatically start MySQL upon booting. It's time to start using your new SQL server.

Share This