Iis+mysql+php Learning

Source: Internet
Author: User
Tags install php iis mysql mysql client versions mysql command line phpmyadmin zend

To find a lot of data versions are very old, new found this seems to be good! Linews may use php!

Below someone said unsuccessful, below I take WIN2003 system as an example, reinstall the configuration demo, add screenshots to everyone, strong hope that the owner add sperm!

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

Full title:

Windows 2000/xp/2003 iis+php+mysql+zend OPTIMIZER+GD Library +phpmyadmin installation Configuration

Apache Support for PHP configuration method is simpler, here is not written

First, software preparation:

The following are the latest official versions as of 2005-4-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


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


Suppose C:\ For the system disk you are using now, if your current operating system is not installed in C:\, please modify it yourself.

Second, install PHP:

(1), download and get Php-5.0.4-win32.zip, extract to C:\Inetpub\php (this path can be arbitrary, but the following if used to this path, please modify accordingly);

(2), and then the C:\Inetpub\php directory of all the DLL files (mainly under the C:\Inetpub\php C:\Inetpub\php\ext under the DLL file) to the C:\Windows\system32, overwriting the existing DLL file;

(3) Copy the Php.exe, Php-win.exe and php.ini-dist three files under the C:\PHP directory to C:\Windows (under Windows 2000 C:\WINNT); Php.ini-dist renamed to PHP.ini, and then opened with Notepad, using Notepad search function


Register_globals = Off

, change off to on;

Search again


Extension_dir =

, and point its path to your PHP directory under the extensions directory, such as: Extension_dir = "C:\Inetpub\php\ext";

Search Find


; Windows Extensions

The following list of


; Extension=php_dbase.dll



; Extension=php_gd2.dll

This is used to support the GD library, the general need, must choose


; Extension=php_ldap.dll



; Extension=php_mbstring.dll

This is not the general use of phpMyAdmin will be a red hint, it must be selected


; Extension=php_mssql.dll

This is used to support MSSQL, optional


; Extension=php_mysql.dll

This is used to support MySQL, to support MySQL must be selected

Remove the previous ";" and the others you need can also get rid of the front, and then close to save the file.

I configured the successful php.ini file example:


(4) Configure IIS to support PHP:

You must first determine that IIS is installed correctly on your system, and if it is not installed, you need to install IIS first and install the following steps:

Open the browser, enter: http://localhost/, see the success of the page after the following action:

PHP supports the CGI and ISAPI two installation modes, and it is recommended to use ISAPI mode. This only explains the ISAPI mode installation method: ISAPI mode installation steps:

In Control Panel, in Administrative Tools, select Internet Services Manager. Stop the service after you turn on IIS, and then on the left "you need to support a PHP Web site" such as the default Web site, right-click to select Properties, in the Open Web Site Properties window, in the ISAPI Filter tab, locate and click the Add button, and in the Filter Name field in the Pop-up Filter Properties window, type: PHP, and then point the executable file to the Php5isapi.dll path, such as: C:\Inetpub\php\php5isapi.dll.

Open the Home Directory tab of the Web Site Properties window, locate and click the "Configure" button, locate and click the "Add" button in the pop-up Application Configuration window, add an extension map to the pop-up window, and click Browse to point the executable file to Php5isapi.dll path, such as: C:\Inetpub\php\php5isapi.dll, and then all the way OK. If you also want to support PHP files with extensions such as. php3,. phtml, you can repeat the "add" step.

Open the document tab of the Web Site Properties window again, and then locate and click the Add button to add the index.php entry to the default Web site startup document list. You can raise the index.php to the highest priority so that the index.php document is automatically searched and opened first when you visit the site.


To determine the application settings and execution permissions for the Web directory, select as pure script, and then close Internet Information Services Manager, and execute the following command at the command prompt:

net stop w3svc

net stop IISAdmin

net start w3svc

Then set the ISAPI extension allowed in the Web service extension to the left of Internet services Manager, Active Server Pages allows

Open the browser, enter: http://localhost/, after you see the Success page, under the IIS root directory to create a new phpinfo.php, which reads as follows:


Phpinfo ();


Open the browser, enter: http://localhost/phpinfo.php, will display the current server support PHP all the information, you can see the Server API mode is: ISAPI.

Third, install MySQL:

If you are downloading Windows Essentials (x86), you will get the Mysql-4.1.11-essential-win.exe and double-click the installation directly. Here I install to the C:\Inetpub\MySQL, the installation process will prompt you not to configure immediately, choose whether to complete the installation. After installation, in the "Start" menu "Run" input: C:\Inetpub\MySQL\bin\mysqld-nt-install, after the successful operation and then input: Net MySQL start, will start the MySQL service; If you want more detailed configuration MySQL, please enter the C:\Inetpub\MySQL\bin directory, run MySQLInstanceConfig.exe, follow the prompts to operate.

If you are downloading Windows (x86), unzip and double-click to perform Setup.exe, step above.

If you are downloading without installer (unzip in C:\), extract directly to C:\Inetpub\MySQL, and in the Start menu run, 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 has the Configuration Wizard MySQL Server Instance Config Wizar, run the following steps to configure the set root password can be

Root password, suggested that the community set a complex point to ensure server security!

You can also configure it in the MySQL command line client by using a command:

First in the Open DOS window, and then into the directory Mysqlbin, and then type the command mysql-uroot-p, enter after the prompt you to lose the password, if just installed MySQL, superuser root is no password, so direct return can enter into MySQL, The MySQL prompt is:mysql>

Modify the password.

Format: Mysqladmin-u username-P Old password password new password

Example: Add a password to root xqin.com first in DOS into the directory mysqlbin, and then type the following command

Mysqladmin-uroot-password xqin.com

Note: Since Root does not have a password at the beginning, the-p old password can be omitted.

Then execute:

SET PASSWORD for ' root ' @ ' localhost ' = old_password (' xqin.com ');

The command here is that the password hashing algorithm used in MySQL 4.1 and its later version verification protocol is incompatible with the old client, and the login with the correct password in phpMyAdmin will also prompt:

Client does not support authentication protocol requested

by server; Consider upgrading MySQL client

So be prepared for the correct use of phpMyAdmin in the back

So the root password is set to xqin.com.

fourth. installation of Zend Optimizer:

After downloading to get Zendoptimizer-2.5.7-windows-i386.exe, directly double-click the installation, the installation process to select the Web server, select IIS, and then prompt you to restart Web server, select Yes, Prompt for backup php.ini before completing installation, click OK after installation completes. Note: If your PHP is more than 4.3 version, then do not use the default installation, and should be customized installation and choose PHP version of PHP 4.3.X, before the correct installation, or will say that the version does not support.

I'm installing it to C:\Inetpub\Zend.


The Zend Optimizer Installation Wizard automatically modifies the php.ini to help you start the engine based on your selections. The following is a brief introduction to the configuration options for Zend Optimizer. The following is the default configuration code in the php.ini after the installation is complete (comments after the semicolon):

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

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

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

The directory of the optimizer, which is not required to be modified by default.


; optimization, where you define how many optimizations to start, the default value is 15, which means that you open 1-4 of the 10 optimization processes at the same time, we can change this value to 1023, which means that all 10 optimizations are turned on.

When the Phpinfo () function is invoked, it displays:

Zend Engine v1.3.0, copyright©1998-2002 Zend Technologies with Zend Optimize

R v2.1.0, copyright©1998-2003, by Zend Technologies indicates successful installation.

Installing the GD Library

This step is actually installed in the front php.ini configuration ~

Find "Extension_dir" in php.ini and then point the path to extension, as follows (assuming your PHP installation path

Diameter: C:\Inetpub\php, set extension_dir = "C:\Inetpub\php, ext", complete this step, in php.ini find "Extension=php_gd2.dll" this line, and remove the front semicolon, GD Library installation complete, with Echophpinfo (), test whether success!

fifth. Installation of phpMyAdmin:

Download gets phpmyadmin-2.6.0.zip, unzip it to the IIS root directory, locate and open config.inc.php, and make the following modifications:

Search $cfg[' Pmaabsoluteuri ' and set your phpMyAdmin URL, such as: $cfg [' pmaabsoluteuri '] = ' http://localhost/phpmyadmin/'; Note that this assumes that phpMyAdmin is in the root directory of the default site

Search $cfg[' Blowfish_secret '], set a good root password here also to fill in such as the root password xqin.com is set to $cfg[' blowfish_secret '] = ' xqin.com ';

Search $cfg[' Defaultlang ' to set it to zh-gb2312;

Search $cfg[' Defaultcharset ' to set it to gb2312;

Search $cfg[' Servers ' [$i] [' Auth_type '], default Config, is unsafe, not recommended, use cookies, set it to $cfg[' Servers ' [$i] [' auth_type '] = ' Cookies ';

Note If this is set to config please set the username and password below! For example:

$cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user-----MySQL connection users

$cfg [' Servers '] [$i] [' password '] = ' xqin.com ';

My configuration file, for reference only!


Open the browser, enter: http://localhost/phpMyAdmin/, if both IIS and MySQL have been started, enter the user root password xqin.com can browse the contents of the database.

phpMyAdmin the specific function, please slowly familiar, here no longer repeat.

All installations are now complete

Post text restrictions above

Added: IIS installation under Windows 2000/xp:

With Administrator account login system, the Windows 2000 installation CD into the CD-ROM drive, into the "Control Panel" click "Add/Remove Programs", and then click on the left "Add/Remove Windows Components", in the pop-up window select "Internet Information Services (IIS), click the "Details" button below, select components, the following components are required: Internet Service Manager, World Wide Web Server, and Common files to determine the installation.

After installation, open the service in Administrative tools in Control Panel, check the IIS Admin service and the World Wide Web Publishing Service, and start it if it is not started.

IIS installation under Windows 2003:

Because IIS 6 of Windows 2003 is set up in the application server, installing the application server defaults to installing IIS 6.0, clicking Configure Your Server on the Start menu, and selecting Application Server (IIS) in the open Configure Your Server Wizard Asp. NET) ", click" Next "to appear" Application Server Options ", you can choose to install with the application server components, the default Select all, click" Next ", appear" Select the Summary Interface ", prompted the options in this installation, the configuration program will automatically follow the" Summary of Selection " To install and configure the options in.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.