Blog of Auzigog – Jeremy Blanchard

I recently had to setup MySQL on Mac OS X Leopard (I was using 10.5.6). I can never find a guide that gets Apache, MySQL and PHP working using the binaries that come packaged with Leopard. I also don’t like using pre-packaged installers like XAMPP and MAMP. This guide is intended for advanced users as very little explanation is given for each step.

Please add a comment if you have any suggestions for improvement.

Apache

Apache comes with Leopard. Enable it by going to System Preferences > Sharing > check “Web Sharing”

Edit /etc/apache2/httpd.conf in your favorite text editor.
To change your root web directory from the default (/Library/WebServer/Documents), Modify your DocumentRoot on line 163:

DocumentRoot "/Users/yourUserNameHere/workspace"

… and change your Directory settings near line 190:

   ...
   AllowOverride All
   ...

To activate the PHP module, uncomment this near line 114:

LoadModule php5_module libexec/apache2/libphp5.so 

… and add this near line 383 to make Apache handle .php files:

AddType application/x-httpd-php .php

MySQL

Download and install MySQL. Install the MySQLStartupItem.pkg package as well. Go to System Preferences > MySQL, start MySQL and check the box to “Automatically Start MySQL Server on Startup”.

Change the MySQL root password:

$ mysqladmin -u root password NEWPASSWORD

Fix permissions for root account

$ mysql -u root -p

mysql> grant all on *.* to 'root'@'%' identified by 'NEWPASSWORD';

Fix the missing mysql.sock file:

$ sudo mkdir /var/mysql
$ sudo chown _mysql /var/mysql
$ sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

PHP

PHP is already installed at /user/bin/php.

Create a configuration file:

$ sudo cp /etc/php.ini.default /etc/php.ini

phpMyAdmin

Download phpMyAdmin and extract it to ~/workspace/pma. Rename config.sample.inc.php to config.inc.php and open it in a text editor.

Near line 17, change your blowfish secret.

PEAR

$ curl http://pear.php.net/go-pear > go-pear.php
$ sudo php -q go-pear.php
$ sudo mkdir /usr/bin/pear

In the installer, choose to edit option and change it to /usr/bin/pear

Edit line 469 in /etc/php.ini to add PEAR to PHP’s include path:

include_path = ".:/usr/bin/pear"

Sources

Guides I used to get this all straightened out

• OS X Apache, MySQL, PHP guide
• OS X PHP/PEAR guide

Computers, Featured, Guides apache, code, leopard, mysql, osx, php, server