There has been a lot of posts on a lot of sites that explain how to get PHP and mySQL working & talking on OSX Leopard, but none that are fully step by step. So with thanks to The Busy Geek ( www.thebusygeek.com ), Here is a comprehensive guide.
You will need a very basic knowledge of using OSX Terminal ( Command Line Commands) and your root password.
Go to Developer.MySQL.com and download the copy that matches your Machine. In my case because I am on a G4 PowerPC iBook, I had to download the 10.4 version (Mac OS X 10.4 (PowerPC, 32-bit)) as there is no 10.5 version for PPC.
Once you have downloaded the package, install all 2 packages, and the preference pane.
Installing the MySQL packages.
Open Terminal ( Applications / Utilities / Terminal.app ) and log in as root;
Enter your root password when prompted.
Navigate to your mysql directory;
If you view the directory you should see something like the following;
COPYING data scripts
EXCEPTIONS-CLIENT docs share
INSTALL-BINARY include sql-bench
README lib support-files
bin man tests
Next we start mySQL.
It should run a whole lot of commands, starting with…
Installing MySQL system tables...
Once that has finished we add the mySQL User permissions
./bin/mysqld_safe --user=mysql &
Which will ( or should ) give this..
Starting mysqld daemon with databases from /usr/local/mysql/data
Now the mySQL root user’s password. and then confirm password and database location.
./bin/mysqladmin -u root password '**PASSWORD**'
./bin/mysqladmin -u root -h **IP_ADDRESS** password '**PASSWORD**'
Now, All going well, Lets hope you get this error:
./bin/mysqladmin: connect to server at '**IP_ADDRESS**' failed
error: 'Host '**IP_ADDRESS**' is not allowed to connect to this MySQL server'
Thats good news, This means mySQL is running and that is step 2 finished.
Next Step, We will install PHP, You think huh? Apple already has a copy of PHP pre-complied in OSX?
Yeah, true, but ( No Offense Apple ) its shit.
Still as root user:
We want to download the newest build of PHP from Marc Liyanage’s site. Thank you to Marc, who has openly releasd and supported Great PHP builds for years! And totally for free!
* Make sure this path represents the newest version.
curl -O http://www2.entropy.ch/download/php5-5.2.5-6-beta.tar.gz
We have used cURL as OSX does not support wGet. Remember the -0.
You will see if download like this…
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
51 85.2M 51 43.4M 0 0 47790 0 0:31:10 0:15:54 0:15:16 52563
Once the download has completed, uncompress it with this command:
tar -zxvf php5-5.2.5-6-beta.tar.gz
Making sure that the file name represents the downloaded file name.
(z = gunzipp, x = uncompress, v = view, f = force ).
View the dir;
You should get a directory looking like this;
OpenSourceLicenses include mysql-5.0.51b-osx10.4-powerpc
OpenSourceVersions lib php5
bin mysql php5-5.2.5-6-beta.tar.gz
Go into the PHP5 Directory; Then view the dir.
bin etc info libphp5.so php.d
entropy-php.conf include lib man share
Then Copy the entropy-php.conf file in to the Apache2 Dir installed by Apple.
cp entropy-php.conf /etc/apache2/other/
Now we need to tell Apache to use our new version of PHP and not the original Apple build.
Open the httpd.conf and comment out the following line.
LoadModule php5_module libexec/apache2/libphp5.so
by placing a # in front of it.
#LoadModule php5_module libexec/apache2/libphp5.so
To Save your changes press “ctrl x”, there will be a prompt to save, press “y”, then press “return” to save with the same filename.
Now restart Apache with this Command
And we are done.
Installing PHP and MmySQL Summary
Begin writing your PHP/mySQL applications.
You can access your local Apache environment at two locations:
or for your User account: