win2003+iis6+php5.33 (FastCGI) +mysql5.1.50 installation configuration

Operating system: Windows 2003 Server SP2 IIS6.0

Required Software: 3

Fcgisetup_1.5_x86_rtw

Mysql-essential-5.1.50-win32

Php-5.3.3-win32-vc9-x86

Download your own

I. Installation of FASTCGI

Double-click to run Fcgisetup_1.5_x86_rtw.msi for installation,

Five files were generated in the C:WINDOWSSYSTEM32INETSRV directory after installation. The following figure:

FastCGI Handler is also in the Web service extensions for IIS.

To this end, the fastcgi installation is complete.

Second, install PHP5.33

Run Php-5.3.3-win32-vc9-x86.msi, the dialog box appears in the installation, select the install directory d:php, and then select IIS FASTCGI until the installation is complete.

Third, configure IIS to support PHP

1.FACTCGI after installation in C:windowssystem32inetsrv Five files, which are useful: Fcgtext.dll,fcgitext.ini;

Open the FastCGI profile Fcgitext.ini, and at the end [Types] Modify to this style:

[Types]
php=php
[PHP]
Exepath=d:phpphp-cgi.exe

where D:phpphp-cgi.exe for PHP installation directory

2. Open IIS Manager, the site right-click-Properties-Home Directory-configuration-add Fcgiext.dll as an executable file, configure the following figure

The above steps have already completed the installation of PHP5.3.3 on IIS6

3. Test Configuration environment:
After the whole process is done, write a test.php test the configuration of the relevant environment, the test code is as follows:
<?php
Phpinfo ();
?>
If the following illustration shows that the fastcgi has been successfully enabled:

Iv. installation of MySQL5.1.50

1, in the choice of installation type
There are "typical (default)", "Complete (Full)", "Custom (user-defined)" Three options, we choose "Custom", there are more options, you can customize the installation location, but also easy to familiarize yourself with the installation process
2, choose the installation content and installation path

1, with the mouse to select the MySQL Server, the program default installation path is

C:Program Filesmysqlmysql Server 5.1,

Click the change on the right side of the installation path ... button to change the default installation path

such as D:/mysql

2, the previous version is the database file in the installation path of the data directory, but this version needs to be set up separately, as shown in the figure above.

It needs to be set through the MySQL Server datafiles, the default path is placed in a hidden directory of the system directory, as shown in the picture, recommended to be modified to the installation directory or a specified location. Easy to back up later. such as: D:/mysql/data
3. Installation Complete
This way "Next", until the reminder software installation is complete, the interface of whether to start the configuration, the default is to "Configure the Mysql Server now" in front of the hook, click "Finish" to end the software installation and start the Mysql Configuration Wizard.

Second, the configuration MySQL server
1. Start Configuration Wizard
Click "Finsh" and the following interface appears, and the MySQL Server Configuration Wizard starts.

Click "Next" to show the following interface,

2, choose a configuration type
You can choose between two types of configuration: Detailed Configuration (verbose configuration) and standard Configuration (standard configuration).
Select the default detailed Configuration (verbose configuration)
3, select the server type
You can select 3 types of servers, and choose which server will affect the MySQL instance's decision on memory, hard disk, and process or use.

Where:
· Developer Machine (Development machine): This option represents a typical personal desktop workstation that can be selected on a local development machine, with MySQL using 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. The MySQL server is configured to use all available system resources.

Select Server Machine
4. Select Database usage
Using the Database Usage dialog box, you can point to 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.

· Multifunctional database: Uses both InnoDB and MyISAM storage engines, and distributes 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.
Select Multifunctional Database

5. Choose InnoDB Table Space
is to select a storage space for InnoDB database files, if modified, to remember the location, when reloading to choose the same place, otherwise it may cause database damage. Note that the default location is generally used.
Some users may want to place the InnoDB table space file in a different location rather than the MySQL server data directory. If your system has larger space or higher-performance storage (such as a RAID storage system, a general server with RAID1 or RAID5, and no development machine), it's a good idea to put the tablespace files in one place alone.
Using the default location, press "Next" to continue.

6. Select Concurrent Connection

It is important to limit the number of concurrent connections that are created with the MySQL server in order to prevent the server from running out of resources. Items in which you can select settings:
· Decision Support (decision Support) (DSS)/olap: This option can be selected if the server does not require a large number of parallel connections. Suppose the maximum number of connections is set to 100, and the average number of parallel connections is 20.
· Online Transaction processing (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. 500

7, Networking options (Network option)
You can enable or disable the TCP/IP network and configure the port number used to connect to the MySQL server.

Whether to enable TCP/IP connections, set ports, if not enabled, you can only access the MySQL database on your own machine,

Put the hook on the front, Port number:3306,

Cancel signed check "Enable Standard mode" (Enable Strictmode)

Firewall Settings "Add firewall exception ..." needs to be checked to add the MySQL service's listening port to Windows Firewall exception to prevent firewall blocking. Press "Next" to continue.
8, select the default character set
You can set the default server character set that applies to all tables, columns, and databases. For Java-written support for Chinese-language programs generally choose to manually set to UTF8.
9. Windows Service Options

By default, the MySQL server is installed as a service, and the service name is MySQL. And the boot automatically starts.
The dialog box also has an option to join the system path

Include Bin directory in Windows path

Check this to make it easy to use the MySQL command at the command line.
10. Security Options

Enter the root password.
Cancel the previous check to enable root access from Remotemachines to allow root users on other machines

Cancel the previous check create an Anonymous account (create a new anonymous user, anonymous users can connect to the database, cannot manipulate data, including queries)
11, the Configuration Confirmation dialog box
The last dialog box is the confirmation (Confirmation) dialog box. To start the configuration process, click Execute.
Modify MySQL Database storage path

Can view the MySQL file directory My.ini file, you can find similar to
Datadir= "D:/beeagle/program files/mysql/mysql Server 5.0/data/" The path is the MySQL Data directory
Default in: "C:documents and Settingsall usersapplication datamysqlmysql Server 5.1Data"
Note: The Application Data folder is hidden!!!
You can modify the configuration above to place the data folder where you want it to be.
-Modified as follows:
1. Stop MySQL, enter and run in the command window: net stop MySQL
To
2. Cut the Data folder in the "C:documents and Settingsall usersapplication datamysqlmysql Server 5.1Data" to the destination. I put it in the "D:phpmysqlmysql Server 5.1″ directory (with MySQL) and the directory" c:documents and Settingsall usersapplication Datamysqlmysql Server 5.1 "deleted.
3. Modify the My.ini file and change the DataDir to datadir= "D:phpmysqlmysql Server 5.1data"
4. Start MySQL, enter and run in the command window: net start MySQL can;
5. After the modification, you can copy the corresponding database attached objects to the inside. ......