{"id":23253,"date":"2024-03-16T01:05:30","date_gmt":"2024-03-16T01:05:30","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/"},"modified":"2024-03-22T00:49:34","modified_gmt":"2024-03-22T00:49:34","slug":"setting-up-an-environment-with-windows-iis-php-and-mysql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/","title":{"rendered":"Setting up an environment with Windows, IIS, PHP, and MySQL."},"content":{"rendered":"

To set up an IIS+PHP+MySQL environment on Windows, you can follow these steps:<\/p>\n

    \n
  1. Install IIS:<\/li>\n
  2. Open the “Control Panel”, select “Programs”, and click on “Enable or disable Windows features”.<\/li>\n
  3. Check the box next to “Web Management Tools”, “World Wide Web Services”, and “ISAPI Extensions” under “Internet Information Services”.<\/li>\n
  4. Click on “OK” to proceed with the installation.<\/li>\n
  5. Installing PHP:<\/li>\n
  6. Download the Windows version of PHP, for example, from the official website php.net.<\/li>\n
  7. Extract the downloaded PHP compressed file and move the extracted folder to the directory of IIS, for example move it to “C:\\inetpub\\wwwroot\\php”.<\/li>\n
  8. Rename the “php.ini-development” file to “php.ini” in the PHP directory.<\/li>\n
  9. Edit the “php.ini” file and modify the following configurations:\n

    Change “;extension_dir = \u201cext\u201d” to “extension_dir = \u201cC:\\inetpub\\wwwroot\\php\\ext\u201d”.
    \nChange “;cgi.force_redirect = 1” to “cgi.force_redirect = 0”.
    \nChange “;cgi.fix_pathinfo=1” to “cgi.fix_pathinfo=0”.
    \nChange “;date.timezone = \u201d to “date.timezone = Asia\/Shanghai” (or modify according to your time zone).<\/li>\n

  10. Set up IIS.<\/li>\n
  11. Open the “Control Panel”, choose “System and Security”, click on “Administrative Tools”, and open “Internet Information Services (IIS) Manager”.<\/li>\n
  12. In the tree menu on the left, expand the server name, right-click on “Website”, and select “Add Website”.<\/li>\n
  13. In the “Add Website” dialogue box, enter the website name and set the physical path to the folder where PHP is located (such as “C:\\inetpub\\wwwroot\\php”).<\/li>\n
  14. In the “Binding” tab, select the IP address and port number (default is 80).<\/li>\n
  15. Click “OK” to finish configuring the website.<\/li>\n
  16. Install MySQL.<\/li>\n
  17. Download the Windows version of MySQL, for example, from the official website mysql.com.<\/li>\n
  18. Run the installation program, follow the instructions to install MySQL, and set the password for the root user.<\/li>\n
  19. Set up MySQL<\/li>\n
  20. Open the “my.ini” file under the MySQL installation directory.<\/li>\n
  21. Locate the section “[mysqld]” and add a line “default-character-set=utf8”.<\/li>\n
  22. Locate the “[client]” section and add a line “default-character-set=utf8”.<\/li>\n
  23. Save and close the “my.ini” file.<\/li>\n
  24. Login to MySQL by entering “mysql -u root -p” in the Windows command prompt.<\/li>\n
  25. Enter the password of the root user to access the MySQL command line interface.<\/li>\n
  26. To create a new database, run the following command: CREATE DATABASE example;
    \nGrant all privileges on the ‘example’ database to ‘username’@’localhost’ with the password ‘password’;
    \nFlush privileges.<\/li>\n
  27. Test environment:<\/li>\n
  28. Create a test file in the website directory of IIS, for example “C:\\inetpub\\wwwroot\\test.php”.<\/li>\n
  29. Enter the following content in the “test.php” file to test:\n

    <\/li>\n

  30. Access the test file by typing “http:\/\/localhost\/test.php” into the web browser to ensure that both PHP and MySQL are functioning correctly.<\/li>\n<\/ol>\n

    In this way, the configuration of setting up IIS+PHP+MySQL environment on Windows is completed.<\/p>\n","protected":false},"excerpt":{"rendered":"

    To set up an IIS+PHP+MySQL environment on Windows, you can follow these steps: Install IIS: Open the “Control Panel”, select “Programs”, and click on “Enable or disable Windows features”. Check the box next to “Web Management Tools”, “World Wide Web Services”, and “ISAPI Extensions” under “Internet Information Services”. Click on “OK” to proceed with the […]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-23253","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nSetting up an environment with Windows, IIS, PHP, and MySQL. - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setting up an environment with Windows, IIS, PHP, and MySQL.\" \/>\n<meta property=\"og:description\" content=\"To set up an IIS+PHP+MySQL environment on Windows, you can follow these steps: Install IIS: Open the “Control Panel”, select “Programs”, and click on “Enable or disable Windows features”. Check the box next to “Web Management Tools”, “World Wide Web Services”, and “ISAPI Extensions” under “Internet Information Services”. Click on “OK” to proceed with the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T01:05:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T00:49:34+00:00\" \/>\n<meta name=\"author\" content=\"Liam\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Liam\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/\"},\"author\":{\"name\":\"Liam\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\"},\"headline\":\"Setting up an environment with Windows, IIS, PHP, and MySQL.\",\"datePublished\":\"2024-03-16T01:05:30+00:00\",\"dateModified\":\"2024-03-22T00:49:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/\"},\"wordCount\":462,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/\",\"name\":\"Setting up an environment with Windows, IIS, PHP, and MySQL. - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T01:05:30+00:00\",\"dateModified\":\"2024-03-22T00:49:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setting up an environment with Windows, IIS, PHP, and MySQL.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\",\"name\":\"Liam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"caption\":\"Liam\"},\"sameAs\":[\"http:\/\/Wilson\"],\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Setting up an environment with Windows, IIS, PHP, and MySQL. - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Setting up an environment with Windows, IIS, PHP, and MySQL.","og_description":"To set up an IIS+PHP+MySQL environment on Windows, you can follow these steps: Install IIS: Open the “Control Panel”, select “Programs”, and click on “Enable or disable Windows features”. Check the box next to “Web Management Tools”, “World Wide Web Services”, and “ISAPI Extensions” under “Internet Information Services”. Click on “OK” to proceed with the […]","og_url":"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T01:05:30+00:00","article_modified_time":"2024-03-22T00:49:34+00:00","author":"Liam","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Liam","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/"},"author":{"name":"Liam","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671"},"headline":"Setting up an environment with Windows, IIS, PHP, and MySQL.","datePublished":"2024-03-16T01:05:30+00:00","dateModified":"2024-03-22T00:49:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/"},"wordCount":462,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/","url":"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/","name":"Setting up an environment with Windows, IIS, PHP, and MySQL. - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T01:05:30+00:00","dateModified":"2024-03-22T00:49:34+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/setting-up-an-environment-with-windows-iis-php-and-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Setting up an environment with Windows, IIS, PHP, and MySQL."}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671","name":"Liam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","caption":"Liam"},"sameAs":["http:\/\/Wilson"],"url":"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23253","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=23253"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23253\/revisions"}],"predecessor-version":[{"id":57219,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23253\/revisions\/57219"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=23253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=23253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=23253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}