Mysql PHP Windows Configuration Tutorial
By installing and configuring MySQL and PHP on a Windows operating system you can host your own powerful Web server. MySQL and PHP are designed to work together to create client/server database applications. PHP is a server side scripting language allowing programmers to create dynamic Web pages. Using these tools together with Windows IIS, anyone can publish her own content to the Web. Creating a private Web server allows you to bypass monthly hosting fees as well as giving the owner full creative control over the server.
Other People Are Reading
Instructions
-
Install Microsoft IIS Server
-
1
Open Control Panel.
-
2
Double-click on "Add/remove programs" if using Windows XP.
Double-click on "Programs and Features" if using Windows Vista/7.
-
-
3
Click on the "Add/remove windows components" button on the left side of the window if using Windows XP.
Click on "Turn windows features on/off" if using Windows Vista/7.
-
4
Install "Internet Information Services (IIS)."
Install and Configure MySQL
-
5
Run the installer file.
-
6
Click "Next." Accept the agreement. Click "Next" again.
-
7
Click "Typical Install," "Install" to begin the installation progress.
-
8
Click "Next" twice. Click "Finish."
-
9
Click "Next" four times. Select a location for the database file. Click "Next" twice more.
-
10
Select a port number and click the box to add a firewall exception. Click "Next" three more times.
-
11
Create a password for the "root" account. Click "Next," "Execute."
-
12
Click "Finish" when the installation is complete.
Install and Configure PHP
-
13
Run the installer file.
-
14
Click "Next." Accept the agreement. Click "Next" again.
-
15
Select a location to install PHP. Click "Next."
-
16
Select "IIS CGI." Click "Next" twice. Click "Install."
-
17
Click "Finish" when the installer completes.
-
18
Open the directory where you installed PHP and open the "php.ini" file.
-
19
Replace the line ";cgi.force_redirect = 1" with "cgi.force_redirect = 0"
-
20
Open "IIS Manager" and click on "Web Service Extensions" from the left pane.
-
21
Click on "Add a new Web service extension" in the right pane.
-
22
Enter "PHP CGI Extension" as the "Extension name." Click "Add."
-
23
Click "Browse" and navigate to "php-cgi.exe" in the directory where you installed PHP.
-
24
Click "OK." Check the box to "set the extension status to Allowed." Click "OK" again.
-
1
Tips & Warnings
Use the defaults rather than changing the installation settings. This will make things easier if you need to modify things in the future.
Use the automatic installers. "ZIP" files are available but require more manual setup.
References
Resources
- Photo Credit Jupiterimages/Comstock/Getty Images
