Intermediary transaction SEO diagnosis Taobao guest Cloud host technology Hall
Windows 2003 Iis6+php5+mysql5+zend Environment Building graphics and text tutorial
New Beginner Tutorials
first, the system agreed to download the Environment software storage location: D:\ServerSoft Environment Software Installation location: D:\ServerRoot PHP Installation location: D:\ServerRoot\PHP mysql installation location: D:\ServerRoot\ MySQL Zend optimizer installation location: D:\ServerRoot\Zend IIS Web site root: D:\wwwroot MySQL database location: D:\ServerRoot\Database php.ini storage location: C:\ Windows\php.ini My.ini Storage location: D:\ServerRoot\MySQL\my.ini II, System environment inspection and preparation of the required software 1. Check to see if the system has IIS clicked: Start-Administrative Tools, check for Internet Information Services (IIS) Manager
2. View the disk partition capacity and decide to use policy to open My Computer view the free space capacity of each disk partition except C, use a larger disk partition as the Web root, and the MySQL database to store the directory (database) and try not to be in the same partition as the Web root. A smaller disk partition can be used as the installation directory partition for the service environment software. 3. Download the Environment software to download and store all software in the Serversoft folder. Mysql-essential-5.0.45-win32.msiphp-5.2.5-win32.zipzendoptimizer-3.3.0a-windows-i386.exe iii. Environment Deployment 1. Install MySQL (1) Install software into the D:\ServerSoft folder, double-click Mysql-essential-5.0.45-win32.msi; figure: Select Custom installation, as shown in figure:
Click "Change" to modify the MySQL installation directory, as shown in figure:
After the file copy installation completed, the MySQL Setup interface, click Finish. Figure: Select Detailed Revisit (detailed configuration), such as Figure: Choose the MySQL run mode: Server Machine as shown in Figure: Note: · Developer Machine (Development machine): This option represents a typical personal desktop workstation. Assume that multiple desktop applications are running on the machine. Configure the MySQL server to use minimal system resources. Server Machine: This option represents the server, and the MySQL server can run with other applications, such as FTP, email, and Web servers. The MySQL server is configured to use the appropriate proportional system resources. Dedicated MySQL server Machine (dedicated MySQL servers): This option represents a server running only the MySQL service. Assume that no other applications are running. The MySQL server is configured to use all available system resources. Choose the MySQL database default storage mode: Non-transactional DB only (MYISAM), as shown: through the Database Usage dialog box, You can point out the table processor used to create the MySQL table. With this option, you can choose whether to use the InnoDB storage engine, and how much of the server resources InnoDB occupy. Note: Multifunctional database: Select this option to use both the InnoDB and MyISAM storage engines and distribute resources evenly between two engines. It is recommended that users who frequently use two storage engines Select this option. Transactional database only (transaction processing databases only): This option uses both the INNODB and MyISAM storage engines, but assigns most server resources to the InnoDB storage engine. It is recommended that you select this option primarily using InnoDB only occasionally using MyISAM. Non-transactional database only (Transactions only): This option completely disables the InnoDB storage engine and assigns all server resources to the MyISAM storage engine. It is recommended that users who do not use InnoDB Select this option. Set the maximum number of MySQL connections: General set to 128-512 between the integers. Note in Figure: : · Decision Support (decision Support) (DSS)/olap: If the server does not require a large number ofRow connections can select this option. Suppose the maximum number of connections is set to 100, and the average number of parallel connections is 20. · Online Transaction 處理 (on-line transaction processing) (OLTP): Select this option if your server requires a large number of parallel connections. The maximum number of connections is set to 500. · Manual Setting (Manual setting): Select this option to manually set the maximum number of concurrent server connections. Select the number of concurrent connections from the previous Drop-down box, and if the number you expect is not in the list, enter the maximum number of connections in the Drop-down box.
set MySQL network parameters, Note: Do not enable Strict mode! Figure: The MySQL server supports a variety of character sets, and you can set the default server character set for all tables, columns, and databases. Change the default character set for the MySQL server using the manual Selected default Character set/collation (character Set dialog box). Figure: Note: · Standard Character Set (standard character Set): Select this option if you want to use Latin1 as the default server character set. Latin1 is used in English and many Western European languages. Best Support for multilingualism (multiple languages supported): Select this option if you want to use UTF8 as the default server character set. UTF8 can store characters in different languages as a single character set. · Manual Selected default Character set/collation (manually selected default character set/proofing rules): Select this option if you want to manually select the default character set for the server. Select the desired character set from the Drop-down list. Service Options dialog box, figure: To install the MySQL server as a service, but not start automatically, check box next to launch the MySQL server automatically option is not selected. Modify the Set root user password, note: Do not start remote connection mode! Note: To set the root password, enter the desired password in the new root password (enter a newer password) and confirm (confirm) two boxes. If you reconfigure an existing server, you will also need to enter the existing root password in the current root password box. To prevent logging on through the network with root, select the box next to the root can only connect from localhost (which only allows you to log on from the local connection root) option. This will increase the security of the root account. To create an anonymous user account, select the box next to the Create Anonymous account option. Creating an anonymous account lowers the security of the server and makes it difficult to login and license. therefore not recommended. Complete the MySQL installation and start the MySQL service.
(2) test whether the MySQL work is normal. Open the cmd Command Prompt window, enter the command: Mysql–u root–p Enter the password, if the normal access to the MySQL console that the MySQL installation is normal. (3) Change the MySQL database directory a) Open the cmd Command Prompt window, enter the command: net stop MySQL stop MySQL service running; b Open D:\ServerRoot\MySQL\my.ini find: DataDir = "D:\Serv Erroot\mysql\data "Modify to: DataDir =" D:\ServerRoot\Database "C" to copy D:\ServerRoot\MySQL\data folder to D:\ServerRoot\ and rename to D:\ Serverroot\database;d Open cmd Command Prompt window, enter command: net start MySQL start MySQL service. e re-test whether MySQL is working properly. (4) Prepare Libmysql dynamic link library to copy D:\ServerRoot\MySQL\bin\libMySQL.dll files to C:\Windows\System32. 2. Install PHP (1) Unzip the downloaded Php-5.2.5-win32.zip file and copy it to: D:\ServerRoot\PHP (2) Enter D:\ServerRoot\PHP folder and rename Php.ini-dist to PHP. INI; (3) Open php.ini file, find: Extension_dir = "./" Change it to; extension_dir = "D:\ServerRoot\PHP\ext" Extension_dir is the directory where the extension library (module) is stored. This is the directory where PHP is used to find dynamic extension modules. (4) Find: Windows Extensions under the Windows Extensions Dynamic module configuration, you need to open the following module support: (remove module configuration per line before the; number can) Extension=php_ Mbstring.dllextension=php_gd2.dllextension=php_mysql.dll (5) Found: Disable_functions = The instruction accepts a comma-delimited list of function names to disable specific functions. Replaced by: Disable_funCtions = Phpinfo,passthru,exec,system,chroot,scandir,chgrp,chown,shell_exec,proc_open,proc_get_status,ini_alter, Ini_alter,ini_restore,dl,pfsockopen,openlog,syslog,readlink,symlink,popepassthru,stream_socket_server (6) Save php.ini file and copy it to C:\Windows\ by the way, don't forget to modify register_globals = off to Register_globals = on. 3. IIS and PHP consolidation configuration-Create a new Web site (1) Start IIS Manager, and create a new Web site (virtual host), such as Figure: (2) Enter the name of the site, change the name only for the identity in IIS, can be entered arbitrarily. Figure: (3) Web site IP address do not need to fill out, the port if no special requirements are maintained 80 can be, and finally correctly enter the site domain name. Figure: (4) Select Wwwroot as the site directory in the site partition. As shown in Figure: (5) For PHP applications, you need to give the site "read" and "Run Script" permissions. As shown in Figure: (6) So far, a new site has been successfully created. 4. IIS and PHP consolidated configuration-enable the site to support PHP (1) To open the properties of the site just built, figure: (2) In the Site Properties window, click the Home Directory tab, click the Configure button, and in the newly ejected Application Configuration dialog box, click the Add button to join the PHP ISAPI support, select executable: D:\ServerRoot\PHP\php5isapi.dll, extension. PHP, restrict action: Get,post. Click OK to add and view in the Application Configuration window. PHP extensions are successfully loaded. If successful, click OK to close the configuration window and return to the Site Properties main window. As shown in Figure: (3) Click the document tab, add Index.htm, index.html, index.php three files to the default content document, and sort all default documents in the order that they are in the front. When you are done, click OK to close the Site Properties Configuration window and return to the IIS manager main interface. (4) Right-click Web Service Extensions to add support for PHP extensions. (5) as shown in the following figure, "newWeb Service Extensions dialog box, "extension" fills in PHP, "file" selects D:\ServerRoot\PHP\php5isapi.dll, and sets the PHP extension to allow by default. As shown in Figure: (6) Restart the IIS service. 5, test PHP support is normal IIS and PHP integration has been completed, the following needs to test the PHP support is normal. (1) Enter the D:\wwwroot\ directory, create a new phpinfo.php file, the content is: <?phpphpinfo ();?> (2) Open IE Browser, enter: http://www.domain.com/ phpinfo.php (3) If the normal display of PHP support information will indicate that the configuration integration is successful. 6, installation Zend Optimizer into the D:\ServerSoft folder, double-click the Zendoptimizer-3.3.0a-windows-i386.exe file download, the installation process is very friendly, but also relatively simple, so no more screenshots here to explain. However, note the following: (1) Zend Optimzer installation directory to be specified as D:\ServerRoot\Zend, (2) in the installation process prompts PHP.ini location is to observe whether it is C:\Windows, if you do not have to manually specify C:\Win Dows (3) The location of the root directory of the IIS Web site prompted during installation, specified as: D:\wwwroot. Zend Optimizer The IIS service is automatically restarted after the installation is complete, and you will need to open the IE browser window again after the reboot, to view the phpinfo.php support information, to see if the Zend Optimizer support information is included, and if not, Zend Optimiz Er did not install successfully! Finally, modify the php.ini file and add the Phpinfo function to the disable_functions. If you have any questions, please come to my group: 15119579 to discuss together