IIS + PHP + MySQL + Zend Optimizer + GD library + phpMyAdmin installation Configuration

Turn from the lost Forum, original post address: http://www.im286.com/viewthread.php? Tid = 878768

Some people say it is not successful. I will use the WIN2003 system as an example to reinstall the configuration demonstration and add it to everyone!

[6.5 supplement] For more information about using this post, please refer to my post on how to configure PHP under WIN host.

Http://www.im286.com/viewthread.php? Tid = 940712

If you encounter problems during the installation process welcome to http://bbs.xqin.com, I will try to help solve!

Complete title:

IIS + PHP + MySQL + Zend Optimizer + GD library + phpMyAdmin installation configuration in Windows 2000/XP/2003

Keywords: Windows IIS configuration support PHP + MYSQL

It is relatively simple to configure PHP in Apache.

I. Software preparation: The following are the latest official versions as of May 20 ,.

PHP (5.0.4): http://cn.php.net/get/php-5.0.4-Win32.zip/from/a/mirror

MySQL (4.1.11): http://www.skycn.com/soft/1262.html

Http://dev.mysql.com/downloads/mysql/4.1.html

Zend Optimizer (2.5.7): http://www.zend.com/store/free_download.php? Pid = 13

PhpMyAdmin (2.6.2): http://www.skycn.com/soft/10687.html

Http://www.crsky.com/SoftView/SoftView_4190.html

Suppose C: \ is the system disk of your current operating system. If your current operating system is not installed in C: \, modify it on your own.

Ii. install PHP:

(1), download to get the php-5.0.4-Win32.zip, decompress to C: \ Inetpub \ php (this path can be arbitrary, but if you use this path below, Please modify the corresponding );

(2) re-run the C: \ Inetpub \ php Directory to all the dll files (mainly C: \ Inetpub \ php C: \ Inetpub \ php \ ext DLL file) copy to c: \ Windows \ system32, overwrite the existing dll file;

(3) set php.exe‑php-win.exe and php. copy the ini-dist files to C: \ Windows (C: \ WINNT in Windows 2000) and C: \ Windows \ php. ini-dist is renamed as php. ini, open it with notepad, and use the search function of notepad to search

CODE: [Copy to clipboard] register_globals = Off

, Change Off to On;

Search again

CODE: [Copy to clipboard] extension_dir =

And direct the path to the extensions directory under your PHP Directory, for example, extension_dir = "C: \ Inetpub \ php \ ext ";

Search found

CODE: [Copy to clipboard]; Windows Extensions

List

CODE: [Copy to clipboard]; extension = php_dbase.dll

Optional

CODE: [Copy to clipboard]; extension = php_gd2.dll

This is used to support the GD library. It is generally required.

CODE: [Copy to clipboard]; extension = php_ldap.dll

Optional

CODE: [Copy to clipboard]; extension = php_mbstring.dll

If you do not select PHPMYADMIN, a red prompt is displayed. Therefore, it is required.

CODE: [Copy to clipboard]; extension = php_mssql.dll

This is used to support MSSQL. Optional.

CODE: [Copy to clipboard]; extension = php_mysql.dll

This is used to support MYSQL. It is required to support MYSQL.

Remove the previous ";". You can also remove the previous one if you need it. Then, close and save the file.

Example of the PHP. ini file after my configuration is successful:

Http://xqin.com/iis/php.ini

(4) Configure IIS to support PHP:

First, make sure that IIS is correctly installed in the system. If IIS is not installed, install IIS first. The installation steps are as follows:

Open your browser and enter http: // localhost/. Then, you can view the successful page and perform the following operations:

PHP supports CGI and ISAPI installation modes. The ISAPI mode is recommended. Here, we will only describe how to install ISAPI:

In "Control Panel", select "Internet Service Manager" in "Administrative Tools", enable IIS, and stop the service, then, right-click the "Web site that you need to support PHP" on the left, for example, "Default Web site", and choose "properties ", in the "ISAPI filter" tab in the "Web site properties" window, find and click "add, in the pop-up "Filter Properties" window, enter: PHP in the "Filter Name" column, and then point the executable file to php5isapi. dll path, for example, C: \ Inetpub \ php \ php5isapi. dll.

Open the "home directory" tab in the "Web site properties" window, find and click "configuration", find and click "add" in the "Application configuration" window that appears, in the displayed window, add a new extension ing with the extension. php, Click Browse to point the executable file to php5isapi. dll path, for example, C: \ Inetpub \ php \ php5isapi. dll, and then click OK. If you want to support PHP files with extensions such as. php3 and. phtml, repeat the "add" step.

Open the "documents" tab in the "Web site properties" window, find and click "add" to add the index. php item to the default Web site startup document list. You can raise index. php to the highest priority, so that the index. php document is automatically searched and opened when you visit the site.

Select "Pure script" in the application settings and execution licenses of the Web directory, close the Internet Information Service Manager, and run the following command at the command prompt:

Net stop w3svc

Net stop iisadmin

Net start w3svc

Then, set the ISAPI extension permission in "WEB Service extension" on the left of "Internet Service Manager". The Active Server Pages allow

Open the browser and enter http: // localhost/. After the successful page is displayed, create a new phpinfo. php file in the IIS root directory. The content is as follows:

CODE: [Copy to clipboard] <? Php

Phpinfo ();

?>

Open your browser and enter http: // localhost/phpinfo. php. All the information about PHP supported by the current Server is displayed. The Server API mode is ISAPI.

3. Install MySQL:

If you are downloading Windows Essentials (x86), you will get the mysql-4.1.11-essential-win.exe, simply double-click the installation. Install C: \ Inetpub \ MySQL here. During the installation process, you will be prompted if you want to configure it immediately. Select No to complete the installation. After the installation is complete, enter C: \ Inetpub \ MySQL \ bin \ mysqld-nt-install in "run" in the "Start" menu. After the installation is successful, enter: net mysql start, the MySQL service will be started. If you want to configure MySQL in more detail, go to the C: \ Inetpub \ MySQL \ bin directory and run MySQLInstanceConfig.exe, follow the prompts.

If you download Windows (x86), unzip the package and double-click to execute Setup.exe. The steps are the same as above.

If you download Without installer (unzip in C: \), decompress it to C: \ Inetpub \ MySQL, and enter C: \ Inetpub \ MySQL \ bin \ mysqld-nt.exe, after running successfully, enter: net mysql start, you can start the MySQL service.

Set a password for MYSQL to ensure security:

The general menu contains the Configuration Wizard MySQL Server Instance Config Wizar. After running the command, follow the steps below to configure and set the ROOT password.

ROOT Password. We recommend that you set complexity to ensure server security!

You can also use the Command configuration in the MySQL Command Line Client:

First, open the DOS window, enter the directory mysqlbin, then type the command mysql-uroot-p, and press enter to prompt you to enter the password. If you have just installed MYSQL, super User root has no password, so press enter to enter MYSQL. The MYSQL prompt is: mysql>

Change the password.

Format: mysqladmin-u username-p old password New password

For example, add a password for the root user, xqin.com, and enter mysqlbin in the DOS directory, and then enter the following command:

Mysqladmin-uroot-password xqin.com

Note: because the root account does not have a password at the beginning, the old-p password can be omitted.

Then execute:

Set password for root @ localhost = OLD_PASSWORD (xqin.com );

The command here is because the password hash algorithm used by MySQL 4.1 and later version verification protocols is incompatible with the old client. You will also be prompted to log on with the correct password in PHPMYADMIN:

Client does not support authentication protocol requested

By server; consider upgrading MySQL client

This is to prepare for the correct use of PHPMYADMIN.

In this way, the ROOT password is set to xqin.com.

4. Install Zend Optimizer:

Download To Get The ZendOptimizer-2.5.7-Windows-i386.exe, directly double-click the installation, installation process you want to select Web Server, select IIS, and then prompt you whether Restart Web Server, select Yes, before the completion of installation prompt whether to back up php. ini, click OK and the installation is complete. NOTE: If your PHP version is 4.3 or later, do not use the default installation. Instead, you should use the custom installation and select PHP version 4.3.X to install it correctly, otherwise, the version is not supported.

Install it in C: \ Inetpub \ Zend

The Installation Wizard of Zend Optimizer automatically modifies php. ini based on your selection to help you start this engine. The following describes the configuration options of Zend Optimizer. The following is the default configuration code in php. ini after the installation is complete (the content after the semicolon is annotated ):

Zend_extension_ts = "C: \ Inetpub \ Zend \ lib \ ZendExtensionManager. dll"

The installation path of the Zend Optimizer module on the hard disk.

Zend_extension_manager.optimizer_ts = "C: \ Inetpub \ Zend \ lib \ Optimizer-2.5.7"

; Optimizer Directory, which does not need to be modified by default.

Zend_optimizer.optimization_level = 15

The degree of optimization. Here we define how many optimization processes are started. The default value is 15, which indicates 1-4 of the 10 optimization processes are enabled at the same time. We can change this value to 1023, enables all 10 optimization processes.

After the phpinfo () function is called, the following information is displayed:

Zend Engine v1.3.0, Copyright (c) 1998-2002 Zend Technologies with Zend Optimize

R v2.1.0, Copyright (c) 1998-2003, by Zend Technologies indicates that the installation is successful.

Install the GD library

This step has been installed in the previous PHP. INI configuration ~

Find "extension_dir" in php. ini and point the path to extension, as shown below (assuming your php installation path is

Path: C: \ Inetpub \ php, set extension_dir = "C: \ Inetpub \ php \ ext". After completing this step. in ini, find the line "extension = php_gd2.dll" and remove the semicolon. After the gd library is installed, use echophpinfo () to test whether it is successful!

5. Install phpMyAdmin:

Download the phpMyAdmin-2.6.0.zip, decompress it to the IIS root directory, find and open config. inc. php, and make the following changes:

Search for $ cfg [PmaAbsoluteUri] and set your phpmyadmin URL, for example, $ cfg [PmaAbsoluteUri] = http: // localhost/phpmyadmin /; note that phpmyadmin is in the root directory of the default site.

Search for $ cfg [blowfish_secret]. After setting the root password, enter $ cfg [blowfish_secret]. For example, set the ROOT password xqin.com to $ cfg [blowfish_secret] = xqin.com;

Search for $ cfg [DefaultLang] and set it to a zh-gb2312;

Search for $ cfg [DefaultCharset] and set it to gb2312;

Search for $ cfg [Servers] [$ I] [auth_type]. The default value is config, Which is insecure and is not recommended. cookie is recommended, set it to $ cfg [Servers] [$ I] [auth_type] = cookie;

Note that if config is set here, set the user name and password below! For example:

$ Cfg [Servers] [$ I] [user] = root; // MySQL user ----- connect to a user in MySQL

$ Cfg [Servers] [$ I] [password] = xqin.com;

My configuration file is for reference only!

Http://xqin.com/iis/config.inc.txt

Open your browser and enter http: // localhost/phpMyAdmin/. If both IIS and MySQL are enabled, enter the ROOT password xqin.com to view the database content.

Please familiarize yourself with the specific functions of phpMyAdmin.

So far, all installation is complete.

Text restrictions in the above post

Supplement: IIS installation in Windows 2000/XP:

Log on to the system with the Administrator account, insert the Windows 2000 installation disc into the disc drive, go to "Control Panel", click "Add/delete program", and then click "Add/delete Windows Components" on the left ", in the displayed window, select "Internet Information Service (IIS)", click the "details" button below, and select a component. The following components are required: "Internet Service Manager", "World Wide Web server", and "public files" are installed.

After the installation is complete, open "Service" in "Administrative Tools" on the "control panel" and check "IIS Admin Service" and "World Wide Web Hing Service, if it is not started, start it.

IIS installation in Windows 2003:

Because IIS 2003 of Windows 6.0 is integrated into the application server, IIS 6.0 is installed by default when you install the application server. Click "Configure your server" in the "Start" menu ", in the open "Configure your server wizard", select "Application Server (IIS, ASP. ", click" Next "to display" application server options ". You can select all components installed with the application server. By default, click" Next ", the "select summary" page appears, prompting the options in this installation. The configuration program will automatically install and configure according to the options in "select summary.