IIS + PHP + MySQL + Zend guard loader (zendoptimizer) + phpMyAdmin environment configuration diagram)

IIS + PHP + MySQL + Zend guard loader (zendoptimizer) + phpMyAdmin environment configuration diagram [updated on 2012-03-14]

Posted on by the ugly face

This article will explain in detail IIS 6.0 + PhP 5.3.10 (vc9 x86 non thread safe) + MySQL 5.5.20 + Zend guard loader (runtime for PHP 5.3) (upgraded zendoptimizer) + phpMyAdmin 3.4.9 environment configuration process. The operating system uses Windows. server.2003 as an example. For other systems, see.

Step 1: Download related software

In this example, the system is windows. server.2003 32-bit. Therefore, the following software downloads the corresponding version. If you are using another version of Windows, please download the corresponding software on your own. If the link is invalid, search for it on the official website.

FastCGI 1.5 for IIS 6 and 5.1
Official download page: http://www.iis.net/download/FastCGI
: Http://go.microsoft.com /? Linkid = 9707432

PHP 5.3.10 vc9 x86 non thread safe
Official download page: http://windows.php.net/download/
: Http://windows.php.net/downloads/releases/php-5.3.10-nts-Win32-VC9-x86.msi

MySQL 5.5.20
Official download page: http://dev.mysql.com/downloads/mysql/5.5.html
: Http://mysql.cdpa.nsysu.edu.tw/Downloads/MySQL-5.5/mysql-5.5.20-win32.msi

Zend guard loader (runtime for PHP 5.3)
Official download page: http://www.zend.com/products/guard/downloads
: Http://downloads.zend.com/guard/5.5.0/ZendGuardLoader-php-5.3-Windows.zip

PhpMyAdmin 3.4.9
Official download page: http://www.phpmyadmin.net/home_page/downloads.php
: Http://nchc.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.4.9/phpMyAdmin-3.4.9-all-languages.7z

Step 2: Install the Configuration Software 1. Install IIS

Open "Control Panel", go to "add or delete programs", and click "Add/delete Windows Components". The "Windows component wizard" dialog box is displayed. Double-click "Application Server", double-click "Internet Information Service", and select "World Wide Web service" (Note: This option can be further selected for filtering. Please select as needed, as shown in), click OK to complete the installation.

 

2. Install FastCGI 1.5 for IIS 6 and 5.1

FastCGI is not integrated in IIS6, so you need to install it to run php. There is nothing to say about this. Install directly. By default, the PHP environment of the system will be changed. After the installation is complete, open the IIS manager and right-click on the website-properties-home directory-configuration, if the PHP option is available, modify the configuration, as shown in figure

 

Open the FastCGI configuration file c: \ windows \ system32 \ inetsrv \ fcgiext. ini and check whether there is any of the following sections. If not, add
[Types]
PHP = PHP
[PHP]
Exepath = D: \ Program Files \ PHP \ php-cgi.exe

To support pseudo-static IIS, see IIS6 pseudo-static configuration (using WordPress fixed link or pseudo-static as an example)

3. install and configure PHP

Php5.3 has vc9 and vc6 versions. The vc6 version is compiled using the Visual Studio 6 compiler. If your PHP version is set up using Apache, you can select vc6. Vc9 is compiled using the Visual Studio 2008 compiler. If your PHP is set up using IIS, you can select vc9.

On the download page, you can also see the versions of thread safe and non-thread safe.
First, it is literally understood that thread safe is thread security, and thread security check is performed during execution, to prevent the new thread from consuming system resources by starting the CGI execution mode. Non-thread safe is non-thread security and does not perform thread security checks during execution.

Let's take a look at two PHP Execution Methods: ISAPI and FastCGI.

The ISAPI is executed in the form of a DLL dynamic library. It can be executed after a user request. After processing a user request, it will not disappear immediately. Therefore, thread security check is required, in this way, the program execution efficiency is improved. If you use ISAPI to execute PHP, we recommend that you select the thread safe version;

FastCGI executes operations in a single thread, so it does not need to perform thread security checks. Apart from the thread security check protection, it can improve the execution efficiency, if you use FastCGI to execute PHP, we recommend that you select the non-thread safe version.

Here I use PHP 5.3.10 vc9 x86 non thread safe, and run php with FastCGI. Download the intermediate installation package and install it directly.

Installer: [38.08 MB]

Sha1: d8b59e885005e5477d3825b8cec6f08c36b906a2

Select the appropriate installation path, and then select IIS FastCGI, as shown in. Next, the installation is complete.

 

You can choose which PHP extensions are enabled during installation. These can be enabled and disabled in PHP. ini.

After installation, find the php. ini file in the PHP installation directory and find the following
[Date]
; Defines the default timezone used by the date functions
Http://php.net/date.timezone
; Date. timezone =
Change
[Date]
; Defines the default timezone used by the date functions
Http://php.net/date.timezone
Date. timezone = Asia/Shanghai

Create a new website in IIS and put the phpinfo. php file. The code is <? PHP phpinfo ();?> . So far, the PHP server is basically complete. Next we will continue to explain the configuration of MySQL + Zend guard loader (zendoptimizer) + phpMyAdmin.

4. Install MySQL 5.5.20

Download the installation package and double-click Install. Click Next. The default installation path is typical. We recommend that you change it to custom. Because typical mode does not allow you to change the installation path, it can only be installed on drive C. Select the custom option. Next, click Next and select the installation path and installed components. Here I am using the default options, which can be selected based on my own situation. Till the completion. In the step to finish, there is an option on the top. This is to configure MySQL.

Next let's take a look at the configuration options, start the configuration, and select next,
Select detailed configuration, as shown in figure

 

Next, this option is to select the type of MySQL application. The first option is the development server, which will occupy as little memory as possible, and the second option is the common Web server, which will occupy a moderate amount of memory, the last one is that this server only runs the MySQL database and takes up all the memory. Here, select the second option. You can select other options based on your needs.

 

The next step is to select the database usage. The first is the multi-function usage, which will optimize the database into a good InnoDB Storage type and an efficient MyISAM storage type, and the second is only for the transaction processing type, it is best to optimize InnoDB, but it also supports MyISAM. The last one is non-transaction processing type and is suitable for simple applications. Only the MyISAM type that does not support transaction processing is supported. Select the first type of function.

 

Next, select the data storage location of InnoDB, which is usually good by default and does not need to be changed.

Next, select the maximum number of connections allowed by MySQL. The first is the maximum number of 20 connections, the second is the maximum number of 500 concurrent connections, and the last is the custom, you can choose one based on your needs. Here I select the third custom item, and enter 20 (you can select or enter according to your specific needs ).

 

Next, select the database listening port. The default value is 3306. If you change it to another port, remember the modified port when connecting to the database. Otherwise, you cannot connect to the MySQL database, we recommend that you do not modify it. Use the default MySQL port: 3306.
Check "add firewall exception for this port" next to port settings. If Windows Firewall is enabled, the port (3306) set here will be automatically excluded (allow network connection) (If you have not enabled Windows Firewall, do not select this option. Windows Server 2003 is not enabled by default ).
The following enable strict mode check box is removed.

 

Next, set the default MySQL encoding. The default encoding is Latin1. We recommend that you select the third custom encoding and change it to utf8.

 

Click Next. In this step, MySQL is set to a Windows service. The service name is the service name named MySQL. The launch the MySQL server automatically check below indicates that the service runs automatically. In this way, you can start and close the MySQL database through the windows service. Then, check the include bin directory in Windows path (this indicates that the environment variable is automatically modified and the ../bin directory is added to the path value ).

Click Next. This step is to set the MySQL Super User Password. This super user is very important and has all permissions for MySQL. Remember the password you set. In the two input boxes (New Root Password and confirm), enter the password to be set twice. For security reasons, generally, do not select "enable root access from remote machines". It is dangerous to allow external database connections. "Create an anonymous account" is used to create an anonymous account. This will cause unauthorized users to access your database illegally. It is recommended that you do not select this option because of security risks.

Next, MySQL is configured. Check whether the MySQL process exists in the service in the management tools on the control panel.

5. Install Zend guard Loader

As zendoptimizer does not support php5.3, Zend guard loader (runtime for PHP 5.3) is installed for users of php5.3 and later versions ). It is easy to extract zendloader. dll and put it in the ext directory of PHP. My files are c: \ Program Files \ PHP \ Ext. Modify PHP. ini and add the following code at the end of the file:

[Zend. loader]
Zend_extension = c: \ Program Files \ PHP \ ext \ zendloader. dll
Zend_loader.enable = 1
Zend_loader.disable_licensing = 0
Zend_loader.obfuscation_level_support = 3
Zend_loader.license_path =

Note: zend_extension paths do not need to be enclosed in quotation marks !! This is the reason why some children's shoes still fail to take effect after some online tutorials.

After the configuration is complete, open the phpinfo. php file and you can see a passage "with Zend guard loader v3.3, copyright (c) 1998-2010, by Zend technologies ".

 

6. Install phpMyAdmin 3.4.9

Official download page: http://www.phpmyadmin.net/home_page/downloads.php
: Http://nchc.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.4.9/phpMyAdmin-3.4.9-all-languages.7z

Download the program, decompress it, and put it under the website directory. Start the website and you can directly open the connection to the database. PhpMyAdmin 3 does not need to be configured. The perfectionist should go to Google.

This entry is published by the ugly face in the programming development category directory, and is labeled with IIS, MySQL, PHP, phpMyAdmin, Zend guard, and server configuration labels. Add a fixed link to favorites.