Win XP + Apache 2.0.59 + PHP 4.4.4 + MySQL 4.1.21 + Zend Optimizer 3.0.1环境配置

作者  Freddy


文档全部用记事本手写


本参考资料是给以下人士使用

需要本地测试环境的、程序、模板风格开发者、模板风格、插件MOD测试者、数据转换者、各类学习爱好者。


更详细的请打开文档阅读！

占位更新

支持
鼓掌

thx
刚好在找这篇文章，因为配置的时候遇到一些问题

支持，我下载了
但是我不明白，如果我已经安装了IIS了，那么要把这个服务停掉吗？
我看到网上有这样的教程，就是安装IIS和Apache共存的教程
你能告诉我吗

原帖由 mailofzgl 于 2006-9-25 16:22 发表
支持，我下载了
但是我不明白，如果我已经安装了IIS了，那么要把这个服务停掉吗？
我看到网上有这样的教程，就是安装IIS和Apache共存的教程
你能告诉我吗

共存的话讨厌了.就不是这么安装方法了.要重新写了.而且不支持这样的做法.那样端口号还要改为8080.很烦的.还不如用IIS支持PHP.

回复下，遇到一个问题

装完之后，登录phpmyadmin没有任何问题，但是修改mysql的密码之后
phpmyadmin打开就会遇到一个问题，提示如下
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

mysql官方说明可能是版本的问题，可是我换了5.0之后问题依旧，不过官方还是提供了解决办法
官方的解释:
MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1, attempts to connect to it with an older client may fail with the following message:

shell>; mysql
Client does not support authentication protocol requested
by server; consider upgrading MySQL client


To solve this problem, you should use one of the following approaches:

Upgrade all client programs to use a 4.1.1 or newer client library.

When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password.

Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:

mysql>; SET PASSWORD FOR
->; 'some_user'@'some_host' = OLD_PASSWORD('newpwd');


alternatively, use update and FLUSH PRIVILEGES:

mysql>; update mysql.user SET Password = OLD_PASSWORD('newpwd')
->; where Host = 'some_host' AND User = 'some_user';
mysql>; FLUSH PRIVILEGES;


Substitute the password you want to use for ``newpwd'' in the preceding examples. MySQL cannot tell you what the original password was, so you'll need to pick a new one.

Tell the server to use the older password hashing algorithm:

Start mysqld with the --old-passwords option.

Assign an old-format password to each account that has had its password updated to the longer 4.1 format. You can identify these accounts with the following query:

mysql>; select Host, User, Password FROM mysql.user
->; where LENGTH(Password) >; 16;


For each account record displayed by the query, use the Host and User values and assign a password using the OLD_PASSWORD() function and either SET PASSWORD or update, as described earlier.

For additional background on password hashing and authentication, see Section 5.5.9, "Password Hashing in MySQL 4.1".

Previous / Next / Up / Table of Contents
若freddy也遇到同样的问题的话，在教程中说明下可能比较好一些，若没有遇到类似的问题，是否我本身有问题？

在Win下还是希望用IIS哦。。。

谢谢,辛苦了,纯支持