Configuring Apache, PHP, MySQL for Windows XP

Instead of using one-step package, I install them piece by pice on Windows XP. Pretty much you just need to follow the installation manuals. But there is a trick.

When you try php on MySQL, you will get an error message of authentication problem and asking you to update the client. The reason you get the error message is that MySQL 4.1 uses an authentication protocal based on a new password hashing algorithm that is not apparently supportet by php (or apache?). Command old_password assigns password with old algorithm.

1. Login as root to mysql at the command prompt (in windows XP sp2 select from menu start->programs->mysql->mysql command line)

2. create new account for example ‘zoooz:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'zoooz'@'localhost';

3. set password in old format:
mysql> SET PASSWORD FOR 'zoooz'@'some_host' = OLD_PASSWORD('mypass');

if you are running postnuke on local machine use ‘localhost’ as host name
And that’s all.

I put all installation requirements in this document . It is modified from this.