[HOWTO] - Setup PHP & MySQL

[yoshi]

Okay before we start I would like to mention that if you screw on any of these commands php will not work. If you wish to get to the document root of apache and use it as real webserver on the net the root of it is located at /library/webserver/documents and the CGI-BIN is located at library/webserver/cgi-executables. I do hope that this HowTo on PHP and MySQL helps you guys learn the terminal and its commands a bit better if you are new to MacOS X. As always please ask any questions you may have. My sources for info will be at the bottom of this HowTo.

PHP PART OF THE HOWTO:
Step 1) Start the Terminal Application.

Step 2) Type "curl -O http://www2.entropy.ch/download/libphp4.so.gz", wait for download to finish

Step 3) Type "gunzip libphp4.so.gz"

Step 4) Type "sudo mv libphp4.so /usr/libexec/httpd/"

Step 5) Type "cd /etc/httpd"

Step 6) Type "sudo apxs -e -a -n php4 libexec/httpd/libphp4.so"

Step 7) Type "sudo perl -p -i.bak -e 's%#(AddType \S+-php[ -])%$1%i' httpd.conf"

Step 8) Type "sudo apachectl graceful" to restart the web server

MYSQL PART OF THE HOWTO:

Step 1) Download and install the package http://www.machowto.com/mysql-3.32.47.pkg.tar

Step 2) Create a new user in the "Users" System Prefs pane:
1. Name: "MySQL User"
2. Short Name: "mysql"
3. Password: whatever you want

Step 3) Open a terminal window and type in the following commands (without the double quotes):

Step 4) type "cd /usr/local/mysql"

Step 5) type "sudo ./scripts/mysql_install_db", enter administrator password when asked

Step 6) type "sudo chown -R mysql /usr/local/mysql/*"

Step 7) type "sudo ./bin/safe_mysqld --user=mysql &"

Step 8) Use it with "mysql test"


Now you should have a perfect web hosting machine that runs PHP and has MySQL on it. It should also run any industry stand scripts such as a forum or a website. Credits are below.

I would like to credit http://www.entropy.ch for most of the infomation used and thanks to jadey for the links.

`Dave

[kilowatt]

I've been down this road before, never could get MySQL to actually start.

Thanks Yoshi for the how-to, I'l be trying it later on today.

I think its critical that we get MySQL and PHP working for every mac os x user who wants it, and I'm glad you wrote a how-to.

I hope Swizcore gets this moved to the Archive, because its quite good!

[Mac Write]

Or you could just uncomment the php lines in the httpd.conf, add index.php to the line with index.htm index.html, and PHP will work.

[yoshi]

actually no you couldn't, the php module isn't in apache by default... it wouldn't work right if at all.. trust me I tried..


`Yoshi

[Mac Write]

Actually that is how it works. Know how i know? I actaully did it. After a 10.1 Clean install, I opened up httpd.conf uncommentedthe following lines, restarted Apache and BOOM. PHPworked.

LoadModule php4_module        libexec/httpd/libphp4.so

AddModule mod_php4.c

AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps

Then added .php to the following line

DirectoryIndex index.html

Then restart Apache and boom PHP will work.

Make sure you have a 10.1 Clean install.

[ScottW]

Very NICE. It all worked. Great!

[yoshi]

Originally posted by Mac Write
Actually that is how it works. Know how i know? I actaully did it. After a 10.1 Clean install, I opened up httpd.conf uncommentedthe following lines, restarted Apache and BOOM. PHPworked.

LoadModule php4_module        libexec/httpd/libphp4.so

AddModule mod_php4.c

AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps

Then added .php to the following line

DirectoryIndex index.html

Then restart Apache and boom PHP will work.

Make sure you have a 10.1 Clean install.

The built in Apple php module isn't really compiled well which is why I ut the extra 30 seconds of work in the above HowTo: I reccomend it for optimal performance. You are indeed right it will work this way, but it works better with the newer module in apache and honestly I feel its safer.

`Yoshi

[lcwid]

Thank you for the instruction. The PHP install worked out great. However, I'm having trouble with install of MySQL. I've always been a Mac user, but I'm a newbie at Unix. After I did the instructions to install MySQL and restarting, I typed the "mysql test" in the terminal and go this reply.
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Any suggestions? Could you recommend a good book for using mysql for newcomers to Unix?
thanx