Installation and configuration instructions for PHP and MySQL in combination with IIS.

N
Netooze
September 26, 2019

On occasion, it is important to use a Windows server as a web server. Installing WAMP is the first thing that springs to mind. Alternatively, you can install Apache, MySQL, and PHP independently. However, there are some exceptions, such as the necessity to utilize IIS instead of Apache. The causes for this can vary greatly. From the system administrator's unwillingness to learn new things to the information security service's extremist viewpoints. Consider how to put together a collection of IIS + MySQL + PHP.

IIS is a collection of Microsoft Internet services, or a web platform. IIS is unique in that it supports a huge number of modules and applications, including MySQL and PHP programming.

Install IIS.

Launch Server Manager.

In the window that opens, select "Add roles and features".

In the window that appears, the Install Roles and Features Wizard, optionally, check the “Ignore this page by default” checkbox. This page will appear every time you try to add a role or features. Press the button " Next ".

In the next step - Installation Type - we check that the option " Install roles and features " is selected. Click on the “ Next ” button.

At the stage of selecting servers, just click “ Next ”, since in our case there is one server.

At the step of selecting server roles, check the “ Web server (IIS) ” checkbox, click on the “ Next ” button.

In the window that opens, click the " Add Components " button. The window will close.

In the remaining window of the wizard, click on the “ Next ” button.

At the stage of selecting components, we recommend that you check the box “Features of the .NET Framework 3.5”. Click " Next ".

At the step “ Web Server Role (IIS)” - “Next ”.

Optionally, you can check additional services of the Web Server role, such as an FTP server. Press the button " Next ".

Confirm the installation by clicking on the “ Install ” button.

We are waiting for the end of the installation process.

The IIS icon will appear in the Server Manager window. We click on it.

In the updated window, right-click on the server name. Select " IIS Manager " from the context menu .

In the dispatcher window that appears, and on the left side, select the current server. In the right part of the window - “ Get new web platform components ”.

A default browser window will open, prompting you to download and install the Web Platform Installer.

Download the installation package, run and install.

After installation, click “Get new web platform components” again.

The Web Platform Installer will launch,

Install MySQL and PHP.

There is a search field in the program window. Let's use it. In the search results, select the PHP package. Click on the “ Add ” button.

Similarly, we find the MySQL package, click “ Add ”. When all packages are added, click on the “ Install ” button.

As on Linux systems, the installer will ask for a password for the MySQL root user. Do not forget the entered password. Click " Continue ".

The central part of the window lists the list of programs that will be installed. To view the text of the license agreement for the installed software, click on the hyperlink. If you agree, click the “ Accept ” button.

We are waiting for the installation to finish.

Installation result. We press " Done ".

As you can see, the “PHP Manager for IIS” package has not been installed. Install it in the same way. We find through the search field, click on the “ Add ” button, then on the “ Install ” button.

Remember that the program was not installed due to an incorrect digital signature. It happens. Download the program from github . Don't forget about the bitness of the OS.

The result will be an MSI file. install as a normal program. You may need to close IIS Manager during installation.

Once the installation is complete, the “ PHP Administrator ” icon will appear in the IIS Manager window . Open it with a double click.

In the window that opens, check phpinfo(). click on the appropriate hyperlink.

In the opened window for selecting a site and URL, select the default site. Click "OK".

The result of the phpinfo() function will be displayed in the IIS manager.

Let's check the MySQL installation result.

Open a PowerShell window and go to the DBMS location directory using the command:

cd “C:Program FilesMySQLMySQL Server 5.5bin”

</code></p>
<p dir="ltr">

</p>
<p dir="ltr">Trying to connect to the DBMS:</p>
<p dir="ltr"><code>./mysql -u root -p

Enter the password specified during installation.

Start your cloud journey? Take the first step right now.