Novice Recommendation: Iis+php+mysql Environment Configuration Tutorial

This article describes how a friend who has just started contacting PHP can configure a PHP environment for their server

First we want the tools:

1, IIS: Of course, this is not less, with the system comes with the good, here will not teach you how to install.

2, Php:php-5.2.0-win32-installer.msi

3, Mysql:mysql-5.0.27-win32.zip

4, Mysqlfront:mysql.front-v3.2.14.3.rar, this is a graphical management of MySQL database Tools

First article: IIS installation

The first article we will not say, how to install IIS all over the Internet, we go directly to the second article.

Article Two: PHP installation

1, the program download:

Suggested to the official PHP website

Website: http://cn2.php.net/get/php-5.2.0-Win32.zip/from/a/mirror

2, program installation:

After decompression or uncompressed, you can see the Php-5.2.0-win32-installer.msi file, double-click the file, pop up the following dialog box, we click Next:

At this point, he will ask you to agree with an agreement that you cannot proceed with the installation. Agree on the agreement Bai, anyway this thing is open source, (should be yes) hehe:

In this step, select the installation folder, and if you want to change it, click Browse. Here, I suggest not to change more. First, the PHP file is not big; second, because this is not a file under Windows, the change does not know if there will be no use of the place. :

Choose your Web service program, IIS/PWS 3 is recommended. This option is tested under XP IIS, which is IIS5.5 under. :

Program installation group interface, don't worry about the next step, see clearly the following instructions:

Open the "+" sign in front of the extensions (extension) shown in, and then drag the scrollbar to the position. Right-click on the GD2 and choose Install this feature (first or two in the selection).

In fact, the difference between the first and the second is not big in this place. If a subordinate option is selected, the first one will only install some default features, and the second is a full installation. Know English friends don't laugh at me, hehe

Similarly, drag to the MySQL one, the same as the previous operation. If your MySQL version is relatively high, it is recommended to install Mysqlli, which is the one under MySQL.

The person you need can also go to the following place and install the PHP Help documentation and pear in the two steps above. And then click Next (Next)

Click Install to start the formal installation of PHP

installation process, waiting for

Installation complete, click Finish to finish the installation

Here, our PHP is finished. Take a break, we'll get started. Third, PHP integration with IIS

Article Three: PHP and IIS Integration

Say, this should be the most important part of PHP installation, if this step did not succeed, the others are white, hehe.

Open IIS, and then right-click on the name of the website you want to support for PHP and select Properties. Of course, if you want all the sites to support PHP, you can also right click on the "Site", select Properties.

This is the pop-up web Properties dialog box, and we want to select the Home Directory tab.

After selecting the Home Directory tab, click "Configure" below this tab

The popup should be the Program Configuration tab, where we want to select "Add"

This step is more critical, this is the click Add after the bounce out.

After "executable", we select "Php-cgi.exe", the previous path is your PHP installation path.

And this, in a lot of previous references, is a DLL file, and this version is Php-cgi.exe.

"Extension" fill in ". php", don't put that point "." Lost it.

The back is always "OK" to the end. Oh

Finally, let's write a test program "test.php" and then open the test. If you see something similar to my picture, congratulations, PHP installation is successful!

test.php content:

[Url=javascript:] Copy Code[/url]

Fourth article: MySQL installation

1, the program download:

Suggested to the MySQL official website

Website: Http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-noinstall-5.0.27-win32.zip/from/pick

2, program installation:

After decompression or uncompressed, you can see the Setup.exe file, double-click the file, pop up the following dialog box, we click Next:

Choose the installation mode, if there is no special requirements, or if you do not understand the situation, please choose typical (classic installation) or if you have enough disk space, you can choose Complate (fully installed). It is recommended (especially for beginners) not to choose custom (customized installation).

I choose the most common classic installation here

When the equipment is finished, click Install to get the installer to start the installation process formally.

Installation status, please wait ...

This is choose whether to register with MySQL website, regardless of him, we choose skip Sign-up (Skip registration)

Complete the installation. If there are no special requirements, you can remove this small tick, click Finish (end) to end the installation. But from a security point of view, let's tick this tick and click Finish to do some initial configuration of MSYQL.

Configure the first interface, click Next (Next) just fine

If there is nothing too special, we choose the second Stanard Configur action (standard configuration).

This screen should show a lot more:

1. Install as Windows service: Installs MSYQL as Windows services. Check this box and you will find MySQL in "Control Panel", "Administrative Tools" and "services". This way, you can improve the level of MySQL running in the system. Recommended check.

2, service name: This is actually no use, is to choose you in the "service" inside see the name just, any one, you familiar with good.

3, Launch the MySQL serverautomatically: automatically open the service. Tick this, and if you open windows, even if you do not log in, MySQL is also running.

4. Include BIN Directory in Windowspath: Tick this to use the MySQL command-line mode anywhere you can directly use CMD. If you are familiar with the command line, this is quite practical. Unfamiliar, it is recommended not to tick.

This is the configuration root (root user) password.

1. Modify Security Settings: Configure safety settings. It is actually the password that configures root (root user).

2, enable root access from Remotemachines: Allows root (root user) to log on from the remote machine. From a security point of view, it is not recommended to check.

3. Create an anymous accounts: Create an anonymous account. No check is recommended.

The following steps are complete installation, there is nothing to say ...

Fifth article: Mysql-front installation

1, the program download:

Recommended download to FF download Station:

Website: http://www.crsky.com/soft/4932.html

2, program installation:

I will not say this process, there is no special place.

Sixth article: Mysql-front Connection Management MySQL

Mysql-front after installation, open. You will see a picture like the one below. (Of course, if you're using it for the first time, the "conversation" should be empty.) )

This time, we click New

What you see here is the dialog box that adds a new dialog.

In the "General" selection card, only a "login information" can be filled out, but this is actually just clay write a name you can identify the data can be. I'll write "localhost" here.

The following icon, there is no practical significance, you should like to change it.

Then click on the "Connections" tab.

Here to fill in a little more.

Server: Fill in the IP or domain name used by your database server.

Port: 3306. The default is 3306, and the general program does not change.

The following options, we do not have to control. Basically, you don't need to. If you want to know clearly, you can check the information yourself or PM me

The Registration tab.

Fill in the user name and data with your database.

The following "database" option, after you fill out the correct server address and user name password, click on the small box behind it, you can select the database to be managed. This feature is especially useful in situations where your users have administrative privileges on multiple data, and you don't want to open all the data at once.

The next two tabs I'm not in the detail. "Autostart" is the automatic execution of some SQL commands when it is opened; The database browser is the custom Mysql-front view

Click OK to go to the login prompt box. Just keep on doing it.

Of course, this conversation can also be obtained by selecting the existing connection and clicking Open when the Mysql-front is just opened.

OK, now you see the database information in MySQL.

Finally, the special note is that. If you're not familiar with MySQL data

Please do not change or delete anything inside the MySQL library.

Failure to do so may result in your database not being used!!!

Novice Recommendation: Iis+php+mysql Environment Configuration Tutorial