Windows 2000/xp/2003 iis+php+mysql+zend OPTIMIZER+GD Library +phpmyadmin installation Configuration

Iis|mysql|window

First, software preparation: The following are the latest official version as of 2005-4-20
PHP (5.1.2): http://www.php.net

MySQL (5.0.19): http://www.mysql.com

Zend Optimizer (2.6.2): http://www.zend.com

phpMyAdmin (2.8.0.2): http://www.phpmyadmin.net

Suppose C:\ For the system disk you are using now, if your current operating system is not installed in C:\, please modify it yourself.

Second, install PHP:

(1) After downloading to get php-5.1.2-win32.zip, extract to C:\php (this path can be arbitrary, but the following if used to this path, please modify accordingly);

(2) then copy C:\php\libmysql.dll and C:\Inetpub\php\ext\php_mysql.dll to C:\Windows\system32;

(3) Copy C:\PHP\php.ini-dist to C:\Windows (C:\WINNT under Windows 2000) and rename it to PHP.ini, then open it with Notepad and search with Notepad's lookup function:

Extension_dir = "C:\PHP\ext"
Refer to the extensions directory in your PHP directory, such as: Extension_dir = "C:\Inetpub\php\ext";

Search Windows extensions and opens only the modules needed to save memory (remove the; number before each module):

Extension=php_gd2.dll
GD Library Support, if you do not open the module, discuz! forum image Watermark can not be used.

Extension=php_mbstring.dll
To support phpMyAdmin, open mbstring.

Extension=php_mysql.dll
Needless to say, it supports MySQL.

(4) Configure IIS so that it supports PHP

You must first determine that IIS is installed correctly on your system, and if it is not installed, you need to install IIS first.

When PHP consolidates with IIS, it supports both CGI and ISAPI two modes, and it is recommended to use ISAPI mode. This only explains the ISAPI mode installation method: ISAPI mode installation steps:

In Control Panel, in Administrative Tools, select Internet Services Manager. Stop the service after you turn on IIS, and then on the left "you need to support PHP on the Web site by right-clicking on the" Properties "and clicking in the ISAPI Filter tab of the Open Web Site Properties window Add button, enter PHP in the Filter Name field in the Pop-up Filter Properties window, and then point the executable file to the path where Php5isapi.dll is located, such as: C:\PHP\php5isapi.dll.

Open the Home Directory tab of the Web Site Properties window, locate and click the "Configure" button, locate and click the "Add" button in the pop-up Application Configuration window, add an extension map to the pop-up window, and click Browse to point the executable file to Php5isapi.dll path, such as: C:\PHP\php5isapi.dll, and then all the way OK.

Open the document tab of the Web Site Properties window again, and then locate and click the Add button to add the index.php entry to the default Web site startup document list. You can raise the index.php to the highest priority so that the index.php document is automatically searched and opened first when you visit the site.

To determine the application settings and execution permissions for the Web directory, select as pure script, and then close Internet Information Services Manager, and execute the following command at the command prompt:

net stop w3svc
net stop IISAdmin
net start w3svc

Then set the ISAPI extension allowed in the Web service extension to the left of Internet services Manager, Active Server Pages allows

Open the browser, enter: http://localhost/, after you see the Success page, under the IIS root directory to create a new phpinfo.php, which reads as follows:

<?php
Phpinfo ();
?>
Open the browser, enter: http://localhost/phpinfo.php, will display the current server support PHP all the information, you can see the Server API mode is: ISAPI.

Third, install MySQL:

Download Windows Essentials (x86) and double-click the installation directly. Here I install to the C:\MySQL, the installation process will prompt you not to configure immediately, choose whether to complete the installation. After installation, in the "Start" menu "Run" input: C:\MySQL\bin\mysqld-nt-install, after the successful operation and then input: Net MySQL start, will start the MySQL service; If you want to configure MySQL in more detail, please enter C:\MySQL\bin directory, run MySQLInstanceConfig.exe, follow the prompts to operate.

If you are downloading Windows (x86), unzip and double-click to perform Setup.exe, step above.

If you are downloading without installer (unzip in C:\), extract directly to C:\MySQL, enter in "Run" on the "Start" menu: C:\MySQL\bin\mysqld-nt.exe, after running successfully, enter: Net MySQL start, the MySQL service can be started.

Set a password for MySQL to ensure security:
The General menu has the Configuration Wizard MySQL Server Instance Config Wizar, run the following steps to configure the set root password can be

Root password, suggested that the community set a complex point to ensure server security!

You can also configure it in the MySQL command line client by using a command:
First in the Open DOS window, and then into the directory Mysqlbin, and then type the command mysql-uroot-p, enter after the prompt you to lose the password, if just installed MySQL, superuser root is no password, so direct return can enter into MySQL, The MySQL prompt is:mysql>

Modify the password.
Format: Mysqladmin-u username-P Old password password new password
Example: Add a password to root xqin.com first in DOS into the directory mysqlbin, and then type the following command
Mysqladmin-uroot-password xqin.com
Note: Since Root does not have a password at the beginning, the-p old password can be omitted.

Then execute:
SET PASSWORD for ' root ' @ ' localhost ' = old_password (' xqin.com ');
The command here is that the password hashing algorithm used in MySQL 4.1 and its later version verification protocol is incompatible with the old client, and the login with the correct password in phpMyAdmin will also prompt:
Client does not support authentication protocol requested
by server; Consider upgrading MySQL client
So be prepared for the correct use of phpMyAdmin in the back

So the root password is set to xqin.com.

Iv. installation of Zend Optimizer:

After downloading to get Zendoptimizer-2.6.2-windows-i386.exe, directly double-click the installation, the installation process to select the Web server, select IIS, and then prompt you to restart Web server, select Yes, Prompt for backup php.ini before completing installation, click OK after installation completes.

V. Installation of phpMyAdmin:
Download get phpmyadmin-2.8.0.2.zip, unzip it to the site root directory, find./libraties/config.default.php and copy to phpMyAdmin root directory named config.inc.php, Make the following modifications:

Search $cfg[' Pmaabsoluteuri ' and set your phpMyAdmin URL, such as: $cfg [' pmaabsoluteuri '] = ' http://localhost/phpmyadmin/'; Note that this assumes that phpMyAdmin is in the root directory of the default site
Search $cfg[' Blowfish_secret '], set a good root password here also to fill in such as the root password xqin.com is set to $cfg[' blowfish_secret '] = ' xqin.com ';
Search $cfg[' Defaultlang ' to set it to zh-gb2312;
Search $cfg[' Defaultcharset ' to set it to gb2312;
Search $cfg[' Servers ' [$i] [' Auth_type '], default Config, is unsafe, not recommended, use cookies, set it to $cfg[' Servers ' [$i] [' auth_type '] = ' Cookies ';
Note If this is set to config please set the username and password below! For example:
$cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user-----MySQL connection users
$cfg [' Servers '] [$i] [' password '] = ' xqin.com ';
My configuration file, for reference only!
Http://xqin.com/iis/config.inc.txt
Open the browser, enter: http://localhost/phpMyAdmin/, if both IIS and MySQL have been started, enter the user root password xqin.com can browse the contents of the database.
phpMyAdmin the specific function, please slowly familiar, here no longer repeat.
All installations are now complete.