Iis+php+mysql+zend OPTIMIZER+GD Library +phpmyadmin installation configuration under Windows 2000/xp/2003

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 of the operating system 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, decompression to C:\php (this path can be arbitrary, but if the following use this path, please modify accordingly);

(2) Copy the 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 to PHP.ini, then open with Notepad and search using Notepad's Find feature:

Extension_dir = "C:\PHP\ext"
Refer its path to the extensions directory in your PHP directory, for example: Extension_dir = "C:\Inetpub\php\ext";

Search Windows extensions and only open the required modules to save memory (before each module is removed; number can be):

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, support MySQL.

(4) Configuring IIS to support PHP

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

When PHP is integrated with IIS to support CGI and ISAPI two modes, it is recommended to use ISAPI mode. This is the only solution to the ISAPI mode installation method: ISAPI mode installation steps:

In Control Panel, in Administrative Tools, select Internet Service Manager, stop the service after you open IIS, and then on the left "you need a PHP-enabled Web site, right-click on" Properties ", and in the" ISAPI Filters "tab of the Open Web Site Properties window, locate and tap Add button, enter PHP in the Filter Name field in the Filter Properties window that pops up, and then point the executable to the path where the 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 application Configuration window that pops up, and a new extension mapping in the pop-up window with the extension. PHP, click Browse to point the executable file to Php5isapi.dll the path, such as: C:\PHP\php5isapi.dll, and then determine all the way.

Open the Documents tab of the Web Site Properties window, 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 when you visit the site, the index.php document is automatically found and opened first.

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

net stop w3svc
net stop IISAdmin
net start w3svc

The ISAPI extension is then set in Web Service extensions on the left side of Internet services Manager to allow Active Server Pages to allow

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

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

Third, install MySQL:

Download Windows Essentials (x86) and simply double-click the installation. Here I install to C:\MySQL, the installation process will prompt you are not immediately configured, select No to complete the installation. After installation, in the Start menu "Run" Input: C:\MySQL\bin\mysqld-nt-install, run successfully and then enter: Net MySQL start, will start the MySQL service, if you want more detailed configuration of MySQL, please enter C:\MySQL\bin directory, run MySQLInstanceConfig.exe, follow the instructions.

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

If you are downloading without installer (unzip in C:), unzip directly to C:\MySQL, enter in "Run" of the Start menu, C:\MySQL\bin\mysqld-nt.exe, and then enter: NET after successful operation 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, after running, follow the steps below to configure the root password to be set

Root password, we recommend a complex point to ensure that the server security!

You can also configure it with commands in MySQL command line client:
First open the DOS window, and then enter 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 directly enter into MySQL, The prompt for MySQL is:mysql>

Change the password.
Format: Mysqladmin-u username-P old password PassWord new password
Example: Add a password to root xqin.com first enter directory Mysqlbin under DOS, and then type the following command
Mysqladmin-uroot-password xqin.com
Note: Because 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 because the password hashing algorithm used by MySQL 4.1 and its later version authentication 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 prepare for the correct use of phpMyAdmin in the back.

This will set the root password 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 when you choose Web Server, select IIS, and then prompt you whether Restart Web server, select Yes, If you are prompted to back up the php.ini before completing the installation, click OK and the installation is complete.

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

Search $cfg[' Pmaabsoluteuri ', set your phpMyAdmin URL, such as: $cfg [' pmaabsoluteuri '] = ' http://localhost/phpmyadmin/'; Note here that the phpMyAdmin is assumed to be at the root of the default site
Search $cfg[' Blowfish_secret ', set the root password is also to fill in the root password, such as xqin.com is set to $cfg[' blowfish_secret '] = ' xqin.com ';
Search $cfg[' Defaultlang '], set it to zh-gb2312;
Search $cfg[' Defaultcharset '], set it to gb2312;
Search $cfg[' Servers ' [$i] [' Auth_type '], the default is config, is unsafe, not recommended, the recommended use of 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
$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 IIS and MySQL are started, enter the user root password xqin.com can browse the database content.
PhpMyAdmin the specific function, please slowly familiar, here no longer repeat.
All installations are now complete.

