64-bit Windows System configuration IIS 7.0+php+mysql diagram

Source: Internet
Author: User
Tags http authentication mysql command line phpmyadmin

One PHP installation

1 unzip the downloaded PHP compression package to a directory (as you like), such as f:/php

2 and then rename the php.ini-dist to php.ini, then copy it to the C:/windows directory.

3 to open the php.ini in a notebook, first find the Extension_dir, in the following double quotes inside the extended directory address, in this case f:phpext

4 re-search extension=php_curl.dll,extension=php_dbase.dll,extension=php_gd2.dll,extension=php_ldap.dll,extension= Php_mbstring.dll,extension=php_mcrypt.dll,extension=php_mysql.dll, put them in front of; (semicolon) all removed, save exit

5 Copy the Libmysql.dll and Libmcrypt.dll in the PHP folder to the C:/windows directory (please note, not c:/windows/system32 below), this step is required, if not copied over, Once used in MySQL will appear "Cannot load MySQL expansion" Situation (I was testing phpmyadmin when found this problem, Baidu has a long time to solve it, faint death), so the PHP configuration part of the completed. Important

PS: Some people say to the PHP folder, and the PHP folder in the Ext file frame all the. dll files are copied to the C:/windows/system32 folder, if you complete all the operations can not display the PHP page, you may try

Two IIS 7.0 configuration

The default in 1windows is not to open the IIS feature, so go manually. To open the Control Panel, click Uninstall, click on or turn off Windows, and then eject the dialog box to select Everything in IIS, as shown

Note, to the front of those plus signs open and then select the hook, or will not be selected, in addition, if you do not use the FTP service, you can not choose

Then click OK and the service will open.

2 after the IIS feature is turned on, then the computer there right button, click Management, in the service and the application there will be more IIS, double hit open IIS

Then right-click in the application pool, select Add application pool, name input php,.net framwork Select No managed code, managed piping Mode Select Classic, click OK, then select Application Pool PHP, click Advanced Settings, as shown

To change the "enable 32-bit application" to true (if 64-bit system, this is a must change, I did not change at the beginning, so I have been unable to display the page ...). )

3 Select the site you have built, such as the local

Then hover over the ISAPI filter, click Add, filter name to fill in PHP, executable file Select Php5isapi.dll, this example median f:/php/php5isapi.dll, click OK

4 Select "Handler Mapping", click Add Script Mapping, request path fill *.php, executable file Select Php5isapi.dll, in this case the bit f:/php/php5isapi.dll, the name is PHP, click OK.

5 Click Directory Browsing, clicking Enable

6 Click Default document, add index.php

7 Select the site, in this case, local, click Advanced Settings

Change the application pool to PHP, and the physical address in the diagram to your site's root directory, fill in the actual situation.

8 So far, IIS is set up, now you can test, create a new text, content bit

<?php

Phpinfo ();

?>

Save, then rename to index.php

Open the browser and enter http://localhost/

Three Zendoptimizer installation (optional)

This is very simple, double-click the installation package, according to the prompts, select the PHP directory, site directory, etc. can be completed

Four MySQL Installation

1 Double click on the installation package and keep pressing the next step to complete the installation

2 after the installation is complete, the following Figure dialog box appears

After clicking Finish, you will enter the Setup interface.

2 after entering the Setup screen (figure)

Click Next to show the image below

Select Standard Configuration, click Next, and show the following image

Here is the password to set the MySQL, according to the hobby set one, and then click Next, will appear in the following figure

Continue to click Next, and the following image appears

Click Execute, and then the following image appears

Click Finish to complete the MySQL settings.

PS: I did not know why I installed a MySQL service, took over the figure in the "Start service" in the item stopped. Results I found a solution after Baidu, is the original service deleted, the way is to open cmd, input

The code is as follows Copy Code

C:>SC Delete MySQL

You can delete a service

You can now test MySQL, click Start, open the MySQL Command line Client

Enter the login password, the following figure appears, the setting is successful

Five phpMyAdmin installation

1 Unpack the files inside the package to any location in the site directory, in this case position f:/web/phpmyadmin (where the web is the root of the site, the files are extracted into the phpMyAdmin folder)

2 due to the phpMyAdmin 3.1.0 The settings are different from previous versions, so be aware that the configuration file is changed to f:/web/phpmyadmin/ Config.default.php in libraries, rename the file to config.inc.php, copy it to the phpMyAdmin directory, open the file in notebook mode, and set it as described below

  code is as follows copy code

$cfg [' Pmaabsoluteuri '] =  '  ;           // Enter your phpMyAdmin address here (Http://localhost/phpmyadmin in this case)

$cfg [' pmaabsoluteuri_disablewarning '] =  FALSE;

$cfg [' pmanorelation_disablewarning ']  = false;

$cfg [' Blowfish_secret '] =  ' sdafasdf ';   //encrypt the cipher when using cookie authentication, you can enter it casually.

$cfg [' Servers '] [$i] The authentication method used by the Auth_type] = cookie;   system   available is (Config,http,cookie)

Config According to the configuration file, no certification, as long as access to the phpMyAdmin can be operated, which is the most dangerous, unless you test in the local, otherwise absolutely do not recommend use;

HTTP authentication is used to access, more secure, is the pop-up window input username and password and then access;

Cookies are validated using cookies and are safe to use.

The code is as follows Copy Code

$cfg [' Servers '] [$i] [' user '] = '; User name for MySQL

$cfg [' Servers '] [$i] [' password '] = '; MySQL password, if you use the cookie method, you can not fill in

After the completion of the save exit, in the browser input http://localhost/phpmyadmin can be used, enter the password can be managed after MySQL

So far, all the settings are complete, I hope this day's experience will be helpful to everyone ...

Summary: In this setting, encountered 3 big problems: The first is the IIS settings did not change that 32-bit application to true, the result of a half-day or unable to display the PHP page; the second is in the process of setting up MySQL, do not know why the original has a MySQL service, Take the boot will not be MySQL; the third, also got me the longest time of a problem, is open phpmyadmin when come pop-up "cannot load MySQL extension", fortunately finally found a solution, The Libmysql.dll and Libmcrypt.dll in the PHP folder are copied into the c:/windows to solve the problem.

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.