[MitkOK]

Surfing the net I found out that people are having problems installing and configuring PHP and MySQL on Leopard.
Here are some simple steps to solve these problems :

Install and configure PHP:

By default PHP and Apache2 are installed on Leopard and the only thing is to enable php module for apache and run the server

1. Open /etc/apache2/httpd.conf and find the line:

 #LoadModule php5_module		libexec/apache2/libphp5.so

Uncomment it ( remove # ) and save the file.



2. Go to System Preferences -> Sharing and check 'Web Sharing'



3. You can place your php files in your /username/Sites directory and view it at 127.0.0.1/~username where username is your account name.







Install MySQL:

1. Go to http://dev.mysql.com.../mysql/5.0.html and download the package for Leopard :



2. Install the packeges and MySQL.prefPane

3. Go to System Preferences -> MySQL and start the server





4. The last thing to do is to to chnage one line in your php.ini file:

Quote

mysql.default_socket = /tmp/mysql.sock

Congratulations. You have PHP/MySQL ready to use OS

Author : Mitko Kostov


Notice : During some of the steps root access is required. Tested on 10.5.2 and 10.5.3.

This post has been edited by MitkOK: 17 June 2008 - 09:08 AM

[level1]

I am using 10.4, and got everything working using mostly the tutorial above but I still think a few things were left off of this tutorial. I'm adding them here:

After you get mysql installed do this from Terminal:

sudo /usr/local/mysql/bin/mysqld_safe --user=mysql &

then

/usr/local/mysql/bin/mysqladmin -u root password XXXX

where XXXX is a password you make up. Don't forget it, write it down store it, save it, keep it love it. What you've done is added a password to the root user for mysql. The root user is root and there is no default password - meaning if you don't add one anyone with access can connect to your mysql db under the user root with no password - scary! I referenced this page so look there for more info.

Now test your connection out - in the code below replace XXXX with the password you just made up

<?php
$hostname = "localhost";
$username = "root";
$password = "XXXX";
$conn = mysql_pconnect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

save this in your Sites folder with a .php extension.

if you don't get an error you are golden!

Now you are safe to play around and you already have the code to connect to mysql

[Dormilich]

if Leopard’s default PHP installation doesn’t fit your needs (you need some extra functions/extensions, e.g. the Suhosin patch, mysqlnd, WDDX) you can install PHP/MySQL from MacPorts. this way you can also keep your installations up to date.