Herself's Webtools

Gad, it is just as miserable and painful as it was under Panther.

1) Install MySQL 4.1 or 5.x

2) Turn on PHP in Apache

3) Fix broken socket

4) Download and install WordPress

Step 1 MySQL:

- Download MySQL 4.1
Unpack it and install and tell it to start on startup.

- Turn on SU account. Open up a Terminal Window and type:
sudo passwd root
Give it a good password. You’ll need su to edit files in a bit

- Configure MySQL
cd /usr/local/mysql/bin
./mysqladmin -u root password
[Give it a good password, if it refuses to connect reboot your computer. Also check in your System Preferences MySQL that MySQL is running and told to turn on at boot. ]

- Once you have the root user set up on MySQL set up an account for yourself
./mysql -u root -pYOURPASSWORD

- You should now see a sql> prompt
GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY ‘userPassword’ WITH GRANT OPTION;
exit;

- Make sure it worked
mysql -u username -puserPassword
Did you get a sql> prompt? If so you’re cool, if not reboot, I’m finding that helps and if not try again. You need to get MySQL running to use Wordpress.

- Life is much easier if you set up a link in your path to mysql

as su

cd /usr/bin

ln -s /usr/local/mysql/bin mysql

Now you should be able to access mysql from any where on the computer.

Step 2: Turn on PHP in Apache
- Turn on WebSharing in System Preferences Sharing

cd /etc/apache2

- Edit httpd.conf , you need to uncomment the line
LoadModule php5_module libexec/apache2/libphp5.so
Thanks and more info here if you are stuck

Step 3 Fix broken socket
- cd/etc/
- copy php.ini.default to php.ini
- edit php.ini
Change the line
mysql.default.socket =
to
mysql.default.socket = /tmp/mysql.sock
Thanks and more help here if you need it for this step

Step 4 Wordpress:

- Download and unpack your favorite version to /Library/WebServer/Documents

- Edit config.php to use the password, and user name and database you created in step 1. If you didn’t create a database do so now.

- type 127.0.0.1/wordpress/ in your browser window and you should see the familiar WP set up screen.
If you do not see the set up screen try this: create this test.php file and it should tell you what is your problem:
if ( $cn = mysql_connect ( “localhost”, “username”, “password” )){
echo “connected”;
}else{
echo “not connected – ” .mysql_error();
}

Use the username and password you set up in mysql.

NOTES:

If you decide to wipe and re-install everything on your computer, you must get PHP/Apache/MySQL up and running BEFORE you do the 10.5.1 update.

If after installing MySQL you are unable to create a database ( errno 13 ) then log on to a terminal as root and change the owner / group of everything in the mysql directories to mysql/mysql.

> chgrp -R mysql *

> chown -R mysql *

You must also create a var and run directory in your /usr/local/mysql directory and make sure they are owned and in the group mysql.