PHP Environment installation configuration (including Iis+php+mysql+zend OPTIMIZER+GD library +phpmyadmin)

Iis+php+mysql+zend OPTIMIZER+GD Library +phpmyadmin installation Configuration
First, software preparation

1, windos2003
2, IIS6.0
3, Php-5.2.11-win32
4, Mysql-5.0.27-win32
5, Zendoptimizer-3.3.3-windows
6, phpMyAdmin-3.2.2.1 (Chongqing Firefly Special Edition)

Second, start the installation

Please make sure the windos2003+iis6.0 is installed.

First step: Install PHP

1, the downloaded Php-5.2.11-win32 extracted to their own need to place the directory;

2, copy the PHP directory php.ini-dist or php.ini-recommended files to C:\Windows directory;

3, the PHP directory of Libeay32.dll, Libmcrypt.dll, Libmhash.dll, Libmysql.dll, Libswish-e.dll, Php5ts.dll and other files copied to C:\Windows\ Under the System32 directory;

4, renamed C:\Windows\php.ini-recommended to PHP.ini, and then opened with Notepad,

(1) Search "register_globals = off" Using Notepad's lookup function to change off to on;

(2) Re-search "Short_open_tag = off" To change the off to on;

(3) Search "Extension_dir =" and point its path to the Ext directory in your PHP directory, for example: Extension_dir = "C:\php\ext"

(3) Search find "Windows Extensions" will be listed below

; Extension=php_gd2.dll
; Extension=php_mbstring.dll
; Extension=php_mcrypt.dll
; Extension=php_mhash.dll
; Extension=php_mysql.dll
; Extension=php_xmlrpc.dll
; Extension=php_zip.dll
Put these before the ";" Remove, the other you need can also remove the front, and then close to save the file.

4. Configure IIS to support PHP:

Open IIS Manager, and then right-click on the Default Web site on the left to select Properties.
In the "Home directory" tab of the Web Site Properties window that opens, locate and click the "Configure" button,
Locate and click the "Add" button in the "Mappings" tab of the "Should program Configuration" window, and click "Browse" in the pop-up window to point the executable to the path of your php5isapi.dll, such as: C:\php\php5isapi.dll.
The extension fills in ". php" and then in the "Action" option below, select "Limit to" and enter "Get,head,post,trace" later and then make sure.
Then add the ". PhP3" extension mappings in the same way.

Open the Documents tab of the Web Site Properties window, locate and click the Add button, and go to the default Web
Add the index.php entry in the 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.

Then right click on "Web Service Extension", select "Add a new Web service extension" in the Popup right menu, enter "PHP" in the "extension" field of the pop-up, then "Add", then click "Browse" to point the file path to the path of your php5isapi.dll, such as: C : \php\php5isapi.dll. Then put the "set extension status to allow" tick.

To determine the application settings and execution permissions for the Web directory, select "Script Only", and then close Internet Information Services Manager,

Execute the following "iisreset" at the command prompt, and PHP is configured.

Test your PHP Environment:
Create a new phpinfo.php in the IIS root directory named: index.php content as follows:

Phpinfo ();
?>

Open the browser, type: http://localhost/,
If the configuration is successful, all information about PHP supported by the current server is displayed.

Step Two: Install MySQL

Open the downloaded MySQL installation file mysql-5.0.27-win32.zip, double-click Unzip, run "Setup.exe", the MySQL Installation Wizard interface appears, press "Next" to continue

Choose the installation type, there are "typical (default)", "Complete", "Custom (User Defined)" Three options, we choose "Custom", there are more options, but also easy to familiarize with the installation process

Click "Change ..." To manually specify the installation directory.

Fill in the installation directory, my is "D:\Server\MySQL5.0", it is recommended not to be placed in the same partition as the operating system, so as to prevent the system backup restore
The data is emptied. Press "OK" to continue.

Go back to the interface and press "Next" to continue.

Confirm the previous settings and, if wrong, press "back" to return to redo. Press "Install" to start the installation.

After the installation process is complete, the mysql.com sign-up interface appears, click "Skip Sign-up" and press "Next" to skip this step.

Now that the software installation is complete, click "Finish" to end the installation of the software and start the MySQL Configuration Wizard by clicking on the "Configure" in front of the MySQL Server.

The MySQL Configuration Wizard Start screen appears and press "Next" to continue.

Choose the configuration method, "Detailed configuration (manual precise configuration)", "Standard Configuration", we select "Detailed Configuration", easy to familiarize with the configuration process.

Select the server type, "Developer Machine (Development test class, MySQL occupies very little resources)", "Server machine (server type, MySQL takes up more resources)", "Dedicated MySQL server machine" ( Dedicated database server, MySQL occupies all available resources) ", people choose according to their own type, generally choose" Server machine ", not too little, will not be full.

Choose the general purpose of MySQL database, "Multifunctional database (Universal multifunction, good)", "Transactional database only (server type, focus on transaction processing, general)", " Non-transactional Database only (non-transactional, simpler, mainly to do some monitoring, counting, MyISAM data type support is limited to non-transactional), with their own use and choose, I choose " Multifunctional Database ", press" Next "to continue.
To InnoDB tablespace configuration, is to select a storage space for InnoDB database files, if modified, to remember the location, re-install the time to choose the same place, otherwise it may cause database corruption, of course, do a backup of the database is no problem, here is not detailed. I have no changes here, use the default location, press "Next" to continue

Select your site's general MySQL traffic, number of simultaneous connections, "decision Support (DSS)/olap (20 or so)", "Online Transaction Processing (OLTP) (500)", " Manual Setting (manually set, you lose a number) ", select" Manual Setting ", in the following selection box, enter" 3000 ", generally enough, press" Next "to continue

Whether to enable TCP/IP connection, set the port, if not enabled, you can only access the MySQL database on your own machine, I am here to enable, put the front tick, Port number:3306, on this page, you can also select "Enable Standard mode" (Enabling Strict Mode), so that MySQL does not allow a small syntax error. If you're still a novice, I recommend canceling the standard mode to reduce the hassle. However, when you are familiar with MySQL, try to use standard mode as it can reduce the possibility of harmful data entering the database. Press "Next" to continue

Next is the MySQL default database language encoding settings, the first is the Latin code, the second is a multi-byte universal UTF8 encoding, is not our universal encoding, here Select a third, and then character set there to select or fill in "GBK", of course, can also use "gb2312", The difference is that GBK's font capacity is large, including all the Chinese characters of gb2312, and the addition of traditional characters, and other chaotic words. Press "Next" to continue.

Next, choose whether to install MySQL as a Windows service, you can also specify the service name (the Services identity name), whether to add the MySQL bin directory to Windows PATH (after joining, you can directly use the file under the bin, instead of indicating the directory name, such as connection, "mysql.exe-u username-p password;" You can, do not point out the full address of the Mysql.exe, very convenient), here all ticked, Service name unchanged. Press "Next" to continue.

This step asks if you want to modify the default root user (super Admin) password (default is empty), "New root password" If you want to modify, fill in the new password here (if it is a reload, and have already set a password here, change the password here may be error, please leave blank, and will "Modify Security Settings "in front of the hook removed, the installation configuration after the completion of a separate password)," Confirm (again lost) "filled again, to prevent the wrong. "Enable root access from remote machines (whether to allow root users to log on to other machines, if it is safe, do not tick, if it is convenient, tick it)". I did not check this option when I installed it. Finally "Create an Anonymous account (create a new anonymous user, anonymous users can connect to the database, cannot manipulate data, including queries)", do not tick, set, press "Next" to continue.

Confirm that the settings are correct, and if wrong, press "back" to return to the check. Press "Execute" to make the settings effective.

Setup finished, press "Finish" to end the installation and configuration of MySQL--here is a more common error, is not "Start service", generally appear in the previous installation of MySQL server, the solution, first to ensure that the previously installed MySQL server completely uninstalled , if not, check whether the previous password has been modified, according to the above, if not, the MySQL installation directory of the Data folder backup, and then delete, after the installation is complete, will install the generated Data folder to remove, the backup Data folder back, Restart the MySQL service again, in which case you might need to check the database and fix it once to prevent data errors.

Step three: Install Zend Optimizer

will be downloaded after the zendoptimizer-3.3.3-windows directly double-click the installation can be,
When the installation process wants you to select Web Server, select IIS, and then prompt you whether to Restart Web server, select Yes, prompt for backup php.ini before completing the installation, click OK after installation is complete.

The Zend Optimizer Setup Wizard automatically modifies the php.ini to help you start the engine based on your choices.

Open PHP.ini Search:
Zend_optimizer.optimization_level=15

optimization, which defines how many optimizations to start, the default value is 15,
Indicates that 1-4 of the 10 optimization processes are also turned on, we can change this value to 1023, which means that all 10 optimization processes are turned on.

Fourth Step: Install Firefly Special Edition phpMyAdmin

Extract the downloaded Phpmyadmin-3.2.2.1.rar to the IIS Default Web site root directory,
Open the browser and enter your phpMyAdmin access address, such as: http://localhost/phpMyAdmin/, if IIS and MySQL.

PHP Environment installation configuration (including Iis+php+mysql+zend OPTIMIZER+GD library +phpmyadmin)