相信大家通過 GOOGLE.COM 和經(jīng)典的N多教程應(yīng)該非常熟悉去架設(shè)PHP+MYSQL服務(wù)器. 本人最近無聊.所以去 WWW.SKYCN.NET 下載了最新的 MYSQL 5.0 以及 PHP 5.0 通過一個(gè)小時(shí)的研究和設(shè)置.實(shí)現(xiàn)了最新的 PHP 5.0 + MYSQL 5.0 + WIN2003. 個(gè)人認(rèn)為還是有必要寫個(gè)教程出來.因?yàn)楹芏喾矫婧屠习姹镜牟槐M相同. 說實(shí)話自己也是查閱了很多官方文檔才解決了很多怪異問題.
=========================
相關(guān)軟件均可以在 WWW.SKYCN.NET 下載.
MYSQL 5.0 FOR WINDOWS PHP 5.0 FOR WINDOWS PHPMYADMIN WINDOWS SERVER 2003
=========================
首先安裝 MYSQL .本來以為新版本的安裝界面應(yīng)該會(huì)花哨點(diǎn). 但是仍然只看到老土的海豚.除了安裝時(shí)間比 4.0 長.當(dāng)然咯.因?yàn)?5.0 比 4.0 體積大很多.
推薦安裝在獨(dú)立的 NTFS 分區(qū)上.比如我服務(wù)器的 F盤.只放服務(wù)器軟件. 路徑為: F:\MYSQL\
然后進(jìn)入 F:\MYSQL\BIN\ 鼠標(biāo)雙點(diǎn) winmysqladmin.exe 首次運(yùn)行會(huì)提示輸入超級(jí)用戶和密碼.就輸入 root 密碼 root 注意啊.如果是對(duì)外服務(wù)器請(qǐng)?jiān)O(shè)置超級(jí)復(fù)雜.比如 Wjwsfjn29szjwh~mysql 翻譯過來就是: 我叫魏舒芬.今年29歲至今未婚. :D
到這里.MYSQL就安裝完畢了.如果不明白請(qǐng)參看深空同學(xué)的相關(guān)文章.
=========================
下面安裝 PHP 5.0 其實(shí)沒什么安裝不安裝的.解壓縮文件.推薦放到 路徑為: F:\PHP\
到這里就應(yīng)該進(jìn)入關(guān)鍵步驟了. 首先復(fù)制 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\
然后復(fù)制 PHP 目錄下 DLLS 目錄里的所有文件到 SYSTEM32 目錄.
COPY F:\PHP\dlls\*.* C:\Windows\System32\
如果是 WINDOWS 2000 就是: C:\WINNT\System32\ 如果是 WIN9X / 2003 就是: C:\Windows\System32\
繼續(xù).復(fù)制PHP目錄下 php4ts.dll 文件到 System32 目錄里.
COPY F:\PHP\php4ts.dll C:\Windows\System32\
=========================
到這里復(fù)制工作全部完成.下面修改 C:\Windows\Php.ini 文件.
請(qǐng)注意.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 字串.默認(rèn)值為1.將其修改為0.并取消前面的;號(hào).
即:
; 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是無法運(yùn)行的.會(huì)有如下提示.
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 的設(shè)置.
查找 [MySQL] 字段內(nèi)的內(nèi)容.修改如下.
mysql.default_port = 3306 // 這里是MYSQL的端口.
mysql.default_host = localhost // 這里是本地主機(jī).
mysql.default_user = root // 這里是用戶
mysql.default_password = Wjwsfjn29szjwh~mysql // 這里是密碼
修改到這里就可以讓 Php 與 MYSQL 關(guān)聯(lián)了. 最后啟動(dòng) PHP 對(duì) MYSQL 模塊支持.
查找 extension=php_mysql.dll 字串.刪除掉前面的 ; 號(hào)
extension=php_mysql.dll
請(qǐng)注意.如果不啟動(dòng) PHP 對(duì) MYSQL 模塊支持.將無法使 PHPMYADMIN 正常工作.將提示:
cannot load MySQL extension, please check PHP Configuration 無法裝入 MySQL 擴(kuò)展,請(qǐng)檢查 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.
=========================
到這里應(yīng)該就沒有很大問題了.如果有配置基礎(chǔ)的朋友應(yīng)該完全可以理解了. 本人在實(shí)際配置的時(shí)候也遇到了很多問題.最后都是耐心查詢官方文檔得到了解決. 在這里要感謝 一個(gè)人の天使 [QQ:5579960 ] 的大力支持.因?yàn)楸救薊文不是很好. 希望大家能有克服困難的毅力.最后想說的是.學(xué)好E文
出處:藍(lán)色理想
責(zé)任編輯:藍(lán)色
|