配置最新的PHP加MYSQL服务器

通过一个小时的研究和设置.实现了最新的 php 5.0 + mysql 5.0 + win2003.
个人认为还是有必要写个教程出来.因为很多方面和老版本的不尽相同.
说实话自己也是查阅了很多官方文档才解决了很多怪异问题.

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

相关软件均可以在 www.skycn.net 下载.

mysql 5.0 for windows
php 5.0 for windows
phpmyadmin
windows rver 2003

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

首先安装 mysql .本来以为新版本的安装界面应该会花哨点.
但是仍然只看到老土的海豚.除了安装时间比 4.0 长.当然咯.因为 5.0 比 4.0 体积大很多.

推荐安装在独立的 ntfs 分区上.比如我服务器的 f盘.只放服务器软件.
路径为: f:\mysql\

然后进入 f:\mysql\bin\ 鼠标双点 winmysqladmin.exe
首次运行会提示输入超级用户和密码.就输入 root 密码 root
注意啊.如果是对外服务器请设置超级复杂.比如 wjwsfjn29szjwh~mysql
翻译过来就是: 我叫魏舒芬.今年29岁至今未婚.

到这里.mysql就安装完毕了.如果不明白请参看深空同学的相关文章.

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

下面安装 php 5.0 其实没什么安装不安装的.解压缩文件.推荐放到
路径为: f:\php\

到这里就应该进入关键步骤了.
首先复制 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\

继续.复制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

相关官方技术资料:

edit your php.ini file:

you will need to change the ‘extension_dir’ tting 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.
t the ‘doc_root’ to point to your webrvers
document_root. ex: c:\apache\htdocs or c:\webroot

choo which extensions you would like to load when php
starts, noting that veral extensions are already built
into the windows relea, e the ction废旧电池的回收与利用 about
windows extensions for details of the built-in extensions.
you can uncomment the: ‘extension=php_*.dll’ lines
in php.ini t谁发明了地动仪o load the 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 t the browscap.ini
to point to: ‘c:\windows\system\inetsrv\browscap.ini’ on
windows 9x/me and ‘c:\winnt\system32\inetsrv\bro小年祝词wscap.ini’
on nt/2000/xp rver.

more information on th党的丰功伟绩e capabilities of browscap can be found here:

www.php.net/manual/en/function.get-browr.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 文件里的如下内容:
查找 cgi.force_redirect 字串.默认值为1.将其修改为0.并取消前面的;号.

即:

; cgi.force_redirect is necessary to provide curity running php as a cgi under
; most web rvers. 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是无法运行的.会有如下提示.

curity alert! the php cgi cannot be accesd directly.

相关官方技术资料:

!note!: since 4.1.2, the php.ini tting cgi.force_redirect defaults to ‘1’
which effectively prevents the cgi from working within iis. you need to t
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 文件关于 mysql 5.0 的设置.

查找 [mysql] 字段内的内容.修改如下.

mysql.default_port = 3306
// 这里是mysql的端口.

mysql.default_host = localhost
// 这里是本地主机.

mysql.default_ur = root
// 这里是用户

mysql.default_password = wjwsfjn29szjwh~mysql
// 这里是密码

修改到这里就可以让 php 与 mysql 关联了.
最后启动 php 对 mysql 模块支持.

查找 extension=php_mysql.dll 字串.删除掉前面的 ; 号

extension=php_mysql.dll

请注意.如果不启动 php 对 mysql 模块支持.将无法使 phpmyadmin 正常工作.将提示:

cannot load mysql extension, plea check php configuration
无法装入 mysql 扩展，请检查 php 的配置。

相关官方技术资料:

to connect to a mysql rver, php needs a t of mysql functions called “mysql extension”.
this extension may be part of the php distribution (compiled-in), otherwi it needs to be loaded dynamically.
its name is probably mysql.so or php_mysql.dll. phpmyadmin tried to load the extension but failed.

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

到这里应该就没有很大问题了.如果有配置基础的朋友应该完全可以理解了.
本人在实际配置的时候也遇到了很多问题.最爱的城堡后都是耐心查询官方文档得到了解决.