Installing php and mysql on iis

The rest of the Installation Wizard screens are pretty self-explanatory. Under Type and Networking , I chose Server Machine since this would actually be a web server and I went with the standard system account for the Windows service screen.

Another option is to open the MySQL 5. You can use the user name and passwords of your choosing. Just be sure to store them in a safe place. The information below details a manual configuration which might still be useful for verification of settings. The non-thread safe edition is required when working with IIS and I stuck with the bit version since, as of this writing, the bit editions are still labeled as experimental.

The package includes a php. This file holds keys and settings, many of which are commented out and can be uncommented to apply specific settings as needed. In your favorite text editor, uncomment the following keys in php. The last setting is a string value without quotes around it, i. First verify that the machine has been assigned the role of a web server and that CGI is installed as a service under IIS.

If this option does not exist, right-click on Roles under the Server Manager tree and add it. If the web server is already installed but CGI does not show as installed under the Application Development group, you can add it by clicking on Add Role Services and selecting it.

You will need to add the php-cgi. The Path setting needs to point the to EXE file. Click OK on both screens to accept both settings. Then click on Add Module Mapping under the Actions menu or right click within the list of mappings and select it from the context menu.

Click Yes. At this point, you will need to restart IIS to ensure that all changes are applied. You can restart it from the Actions menu in IIS or open a command window in Administrator mode and type iisreset at the prompt. After IIS stops and restarts, type exit to close the window. Name the file phpinfo.

HTTP Error If the physical path that you entered in step 5 is to a remote share, click Connect as to specify credentials that have permission to access the path.

If you do not use specific credentials, select the Application user pass-through authentication option in the Connect As dialog box. The default value in the IP address box is All Unassigned. If you do not have to make any changes to the site, and you want the website to be immediately available, select the Start Web site immediately check box. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Please rate your experience Yes No.

Any additional feedback? Open a MySQL command prompt, and use the following sequence of commands:. Change the name of the root user with the following sequence of commands from the command prompt:. The newly created user does not have any privileges on the MySQL server by default. To create a new database, type the following command:. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode.

Please rate your experience Yes No.