WinXP + Apache +PHP5 + MySQL + phpMyAdmin安裝全功略

I finally got this to work, so I will post my findings here.

//PHP 5 : Windows build needs a MySQL DLL
//PHP 5.0 doesn't come with mysql support... You have to get the librariesyourself...
//I think u can get them from mysql.com

// PHP 5 Beta 2
//The file php_mysql.dll comes with these snapshots, as well as a new version of libmySQL.dll,
//so I suggest a full upgrade to Beta 2 instead of just extracting php_mysql.dll for use with Beta 1.

--------------------------------------------------------
到 www.jetdown.com 下載下面三種軟體,做好安裝準備

apache_2.0.47-win32-x86-no_ssl.msi
mysql-4.0.14-win.zip
phpMyAdmin-2.5.3-rc1-php.zip
----------------------------------------------------------------------------------------------
PHP 5 Beta 2 http://snaps.php.net/win32/php5-win32-latest.zip size：5.87 MB (6,162,835 bytes)
----------------------------------------------------------------------------------------------

<1>安裝配置PHP
　　1.解壓縮PHP壓縮包到C:\php\

2.複製C:\php\目錄下的php4ts.dll及C:\php\dlls目錄下的所有檔案到windows安裝目錄的系統檔案夾裡
(win9x/me是system目錄，winNT,2k/winXP,2003是system32目錄)

複製C:\php\php.ini-dist到windows安裝目錄下（如：c:\windows），並將其改名為php.ini。用記事本開啟，修改一下資訊：
　　搜尋extension_dir = ./ 這行，並將其路徑指到你的PHP目錄下的extensions目錄，比如：
　　extension_dir = C:\php\extensions

　　如若想支援更多模組，，搜尋：
;Windows Extensions
;Note that MySQL and ODBC support is now built in, so no dll is needed for it.

下面都用分號在前面注釋掉了支援的擴充模組，如果你想PHP支援某個模組，請將前面的“;”去掉即可
修改完成後,儲存php.ini，到此完成PHP的安裝和配置。
我們在下面加入一行
extension=php_mysql.dll

//Note 1: The extension dir need not be ".\", as Hermawan mentioned. It works fine for me with the extensions subdir where the other extensions are located.

//Note 2: The php.ini file need not be in the Apache root, as lars mentioned. It works fine for me in the Windows dir.

<2>安裝Apach2
1.備份　C:\Program Files\Apache Group\Apache2\conf\httpd.conf 檔案。
2.用記事本開啟C:\Program Files\Apache Group\Apache2\conf\httpd.conf
找到：
#NameVirtualHost *
修改為：
NameVirtualHost 127.0.0.1　//或localhost
找到：
<VirtualHost 127.0.0.1>
修改下面幾行：
ServerAdmin (你剛才安裝時候輸入的管理員信箱)
DocumentRoot C:\Program Files\Apache Group\Apache2\htdocs
ServerName Apache2
ErrorLog C:\Program Files\Apache Group\Apache2\logs\error_log
CustomLog C:\Program Files\Apache Group\Apache2\logs\access_log common
</VirtualHost>
找到：
AddType application/x-tar .tgz
在下面添加以下兩行：
AddType application/x-httpd-php .php
AddType image/x-icon .ico
找到：
#LoadModule ssl_module modules/mod_ssl.so
在下面添加一行：
LoadModule php5_module C:\php\sapi\php4apache2.dll //這裡php5_module是關鍵，如果php4_module apache就無法啟動了
增加預設檔案：
找到DirectoryIndex * 這行，可以這樣修改，添加預設的檔案名稱：
DirectoryIndex index.php default.php index.htm index.html default.htm default.html
儲存檔案，重起apache伺服器。

最後，在該檔案末尾加上下面兩行
ScriptAlias /php/ "c:/php/"
Action application/x-httpd-php "/php/php.exe“

到此Apache的PHP環境已經完全建立了。

<3>測試：
　　用記事本建立個檔案，寫下下面幾行，儲存到C:\Program Files\Apache Group\Apache2\htdocs目錄下，這個目錄就是你的網站跟目錄，命名為phpinfo.php.然後在瀏覽器中輸入http://localhost/phpinfo.php 就可以看到想盡的關於PHP的資訊了。

phpinfo.php代碼如下：
<?php

phpinfo();

?>

<4>安裝mysql

1.按預設安裝在C:\mysql

Copy the following files to the Apache modules directory:

php\php4ts.dll
php\sapi\php4apache2.dll
php\dlls\iconv.dll

If any of these files are missing in the modules directory, Apache will fail to start.

Be sure the extension can find the following files:

php_mysql.dll
iconv.dll
libmySQL.dll

If any of them can't be found, Apache will start but will issue a warning like this: "Unknown(): Unable to load dynamic library 'c\php\extensions\php_mysql.dll" - The specified module could not be found."

php_mysql.dll should be in the extensions directory.

iconv.dll should be in the Apache modules directory.

libmySQL.dll must be either in the Apache root directory or the Windows system directory. I prefer the former because it's cleaner, as other applications don't necessarily use this MySQL library version.

Note 3: Be sure to use the libmySQL.dll file bundled with PHP. In my case, trying to use the libmySQL.dll from the MySQL 4.1 alpha package resulted in this error message: "Unknown(): Unable to load dynamic library 'c:\php\extensions\php_mysql.dll" - The specified procedure could not be found."

Start Apache and everything should be fine.

2.運行C:\mysql\bin\winmysqladmin.exe 設定user 和password
3.運行mysql,測試一下
mysql> show databases;

+-----------+
| Databases |
+-----------+
| mysql |
| test |
+-----------+

如果出現以上畫面，表明mysql已經安裝成功；

2.更改MySQL系統之管理者密碼(新密碼的地方，換成您要設定的密碼)
mysql> UPDATE user SET password=password('新密碼') where user='root';

3.編輯php5中的開機檔案php.ini,將mysql和php5串連起來.
mysql.default_port=
mysql.default_host=
mysql.default_user=
mysql.default_password=
改為：
mysql.default_port=3306 說明的是mysql的預設連接埠一般為3306
mysql.default_host=localhost 說明的是mysql的預設主機名稱
mysql.default_user=jinchao 說明的是mysql的預設的使用者名稱(root是最進階使用者)
mysql.default_password=666666 設定管理員的口令

修改完後將apache重啟,查看phpinfo頁面.

<5>安裝phpmyadmin

修改 C:\Program Files\Apache Group\Apache2\htdocs\phpMyAdmin\config.inc.php
尋找以下這麼一段：
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
在這段之後再繼續尋找：

找到 $cfg['Servers'][$i]['auth_type'] = 'cookie'; 將 『 config 』改為 『 cookie 』或 『 http 』
找到$cfg['Servers'][$i]['host'] = 'localhost'; 視情況做相應修改
找到$cfg['Servers'][$i]['user'] = 'root'; 視情況做相應修改
找到$cfg['Servers'][$i]['password'] = ''; 視情況做相應修改
找到$cfg['Servers'][$i]['port'] = '3306'; 視情況做相應修改