設置最新的PHP加MYSQL服務器

通過一個小時的研究和設置.實現(xiàn)了最新的 PHP 5.0 + MYSQL 5.0 + WIN2003.
個人認為還是有必要寫個教程出來.因為很多方面和老版本的不盡相同.
說實話自己也是查閱了很多官方文檔才解決了很多怪異問題.

=========================

相關(guān)軟件均可以在 WWW.SKYCN.NET 下載.

MYSQL 5.0 FOR WINDOWS
PHP 5.0 FOR WINDOWS
PHPMYADMIN
WINDOWS SERVER 2003

=========================

首先安裝 MYSQL .本來以為新版本的安裝界面應該會花哨點.
但是仍然只看到老土的海豚.除了安裝時間比 4.0 長.當然咯.因為 5.0 比 4.0 體積大很多.

推薦安裝在獨立的 NTFS 分區(qū)上.比如我服務器的 F盤.只放服務器軟件.
路徑為: F:\MYSQL\

然后進入 F:\MYSQL\BIN\ 鼠標雙點 winmysqladmin.exe
首次運行會提示輸入超級用戶和密碼.就輸入 root 密碼 root
注意啊.如果是對外服務器請設置超級復雜.比如 Wjwsfjn29szjwh~mysql
翻譯過來就是: 我叫魏舒芬.今年29歲至今未婚.

到這里.MYSQL就安裝完畢了.如果不明白請參看深空同學的相關(guān)文章.

=========================

下面安裝 PHP 5.0 其實沒什么安裝不安裝的.解壓縮文件.推薦放到
路徑為: F:\PHP\

到這里就應該進入關(guān)鍵步驟了.
首先復制 PHP 目錄下的 Php.ini-dist 到 C:\Windows\ 并將文件名修改成為 Php.ini

COPY F:\PHP\Php.ini-dist C:\Windows
Ren Php.ini-dist Php.ini

如果是 WINDOWS 2000 就是: C:\WINNT\
如果是 WIN9X / 2003 就是: C:\Windows\

然后復制 PHP 目錄下 DLLS 目錄里的所有文件到 SYSTEM32 目錄.

COPY F:\PHP\dlls\*.* C:\Windows\System32\

如果是 WINDOWS 2000 就是: C:\WINNT\System32\
如果是 WIN9X / 2003 就是: C:\Windows\System32\

繼續(xù).復制PHP目錄下 php4ts.dll 文件到 System32 目錄里.

COPY F:\PHP\php4ts.dll C:\Windows\System32\

=========================

到這里復制工作全部完成.下面修改 C:\Windows\Php.ini 文件.

請注意.5.0的版本修改與4.0并不完全相同.需要注意的如下.

查找 extension_dir 字串.修改為你 PHP 目錄里 extensions 的路徑.

; Directory in which the loadable extensions (modules) reside.
extension_dir = F:\PHP\extensions

相關(guān)官方技術(shù)資料:

Edit your php.ini file:

You will need to change the 'extension_dir' setting to
point to your php-install-dir, or where you have placed
your 'php_*.dll' files. ex: c:\php

If you are using OmniHTTPd, do not follow the next step.
Set the 'doc_root' to point to your webservers
document_root. ex: c:\apache\htdocs or c:\webroot

Choose which extensions you would like to load when PHP
starts, noting that several extensions are already built
into the Windows release, see the section about
Windows extensions for details of the built-in extensions.
You can uncomment the: 'extension=php_*.dll' lines
in php.ini to load these extensions.

Note that on a new installation it is advisable to first get
PHP working and tested without any extensions before enabling
them in php.ini.

On PWS and IIS, you can set the browscap.ini
to point to: 'c:\windows\system\inetsrv\browscap.ini' on
Windows 9x/Me and 'c:\winnt\system32\inetsrv\browscap.ini'
on NT/2000/XP Server.

More information on the capabilities of browscap can be found here:

www.php.net/manual/en/function.get-browser.php

Note that the mibs directory supplied with the Windows distribution
contains support files for SNMP. This directory should be moved to
DRIVE:\usr\mibs (DRIVE being the drive where PHP is installed.)

然后與 PHP 4.0 不同的是.需要修改 Php.ini 文件里的如下內(nèi)容:
查找 cgi.force_redirect 字串.默認值為1.將其修改為0.并取消前面的;號.

即:

; cgi.force_redirect is necessary to provide security running PHP as a CGI under
; most web servers. Left undefined, PHP turns this on by default. You can
; turn it off here AT YOUR OWN RISK
; **You CAN safely turn this off for IIS, in fact, you MUST.**
cgi.force_redirect = 0

切記如上修改的地方.否則PHP 5.0是無法運行的.會有如下提示.

Security Alert! The PHP CGI cannot be accessed directly.

相關(guān)官方技術(shù)資料:

!NOTE!: Since 4.1.2, the php.ini setting cgi.force_redirect defaults to '1'
which effectively prevents the cgi from working within IIS. You need to set
up at least a minimal php.ini file with the following directive:

cgi.force_redirect = 0

If it doesn't work immidiately, make sure you have the php.ini file in the
right place (%SYSTEMROOT%\php.ini).

接下來修改 Php.ini 文件關(guān)于 MYSQL 5.0 的設置.

查找 [MySQL] 字段內(nèi)的內(nèi)容.修改如下.

mysql.default_port = 3306
// 這里是MYSQL的端口.

mysql.default_host = localhost
// 這里是本地主機.

mysql.default_user = root
// 這里是用戶

mysql.default_password = Wjwsfjn29szjwh~mysql
// 這里是密碼

修改到這里就可以讓 Php 與 MYSQL 關(guān)聯(lián)了.
最后啟動 PHP 對 MYSQL 模塊支持.

查找 extension=php_mysql.dll 字串.刪除掉前面的 ; 號

extension=php_mysql.dll

請注意.如果不啟動 PHP 對 MYSQL 模塊支持.將無法使 PHPMYADMIN 正常工作.將提示:

cannot load MySQL extension, please check PHP Configuration
無法裝入 MySQL 擴展，請檢查 PHP 的配置。

相關(guān)官方技術(shù)資料:

To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension".
This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically.
Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.

=========================

到這里應該就沒有很大問題了.如果有配置基礎(chǔ)的朋友應該完全可以理解了.
本人在實際配置的時候也遇到了很多問題.最后都是耐心查詢官方文檔得到了解決.