Install Mysql Php Windows Server

/ Comments off
  1. Mysql Php Connect
  2. Mysql Download For Windows Server
  3. How To Install Apache Mysql Php On Windows Server 2008
  4. Install Mysql Php Windows Server 2012
  5. Install Mysql Php Windows Server Error
Jun 20, 2017

Feb 14, 2008  Configure a MySQL Instance. Click Next in the Instance Configuration Wizard. Select Detailed Configuration, and then click Next. Select a server type that best suits your environment. It is recommended to set up a separate MySQL server; when prompted to select a server type. These are instructions for installing on Windows 7 desktop (they may also be useful for a server install with some thought to security) using individual components rather than a one click installer. This is intended only as a testing/evaluation install via 'localhost'. Proper server configuration and security is not considered. A Cloud Server with Windows 2016. Note: MySQL is installed and running on a Standard Windows installation by default. If your server was created with a Minimum installation, the following steps will install MySQL on the server. Download the MySQL Installer Connect to the server with Remote Desktop. In this article, we will discuss “How to Setup Apache, PHP & MySql on Windows 10″. When you are planning to install Apache, PHP & MySQL on Windows 10 machine, then We have two options to do this as given below. Jul 13, 2018  How To Install and Configure MySQL for PHP Applications on Windows IIS 7 Step 1- Installing MySQL on Windows. MySQL should be installed on a dedicated server instead. Step 2 - Configuring MYSQL Instance. Now run the 'MySQL Server Instance Configuration Wizard.' Step 3 - Provision a New User. Setup MySql database. Click on wamp server icon on your system tray and go to phpMyAdmin. You get a browser window asking for username and password. Type root as username and don’t enter anything in the password field(by default.

How install Apache 2.4 PHP 7.1 and MySQL 5.7.18 on Windows Server 2016

Introduction

This post is a how to guide for installing Apache, PHP and MySQL on the latest release. In this post like previous we will cover installing all the programs individually. This will cover installing 64 bit versions of the programs.

Apache 2.4 Install

First download Apache 2.4 from http://www.apachelounge.com/download/ (httpd-2.4.25-win64-VC14.zip) Apache 2.4.25 VC14
This release is supported by the PHP 7.1.6 install from windows.php.net for Apache 2.4.

Extract the zip copy Apache24 to the root of C:. This will be C:Apache24 when it is all done.

Microsoft Visual C++ 2015 Runtime

Download and install Microsoft Visual C++ VS 2015 x64 from https://support.microsoft.com/en-us/help/2977003/the-latest-supported-visual-c-downloads this is required for Apache to run.

PHP 7 and higher

Download php-7.1.6-Win32-VC14-x64 (thread safe) from http://windows.php.net/download/ . Extract and rename folder to php and move to C:.

Edit Apache’s config file, c:Apache24confhttpd.conf and add the following lines to the bottom of the file.

Mysql
2
4
AddHandler application/x-httpd-php.php
PHPIniDir'C:/php'

While we are at it we can add index.php to Apache’s list just incase we want to have a starting page as php.

Find Directory index and add index.php

Save the file changes. Next we need to register the path where the applications reside. This is done by editing the PATH variable.

Add

to PATH in Environment variables. PATH ENVIRONMENT (Control Panel System Properties Advanced Environment Variables System variables Path).
Example:
;c:php;c:apache24;c:apache24bin;

We can also set this from the command prompt.

setx PATH “%PATH%;c:php;c:apache24;c:apache24bin” /M

Save and reboot the system.

Server

Next we need to input a value for ServerName variable. You will have to un-comment it. Save the changes to the config file. Next move to the Register Apache Service step.

Register Apache Service

Now let’s register Apache as a service. Open a command prompt and type.

If do not want Apache starting automatically at start-up/reboot:

Command line

Now lets check Apache settings by issuing the command,

c:Apache24binhttpd -S

At this point we can start Apache service and open a web browser and go to localhost and get the Apache It Works! page.

PHP Edits

Now we have to do a few edits to the php.ini file to tell it to load support for mysql and the location for the extensions. Since there is not a already set php.ini file we need to rename one of the two examples to php.ini.

Rename c:phpphp.ini-development to php.ini

Now let’s edit php.ini
Uncomment extension directory.

2
4
6
8
;Directory inwhich the loadable extensions(modules)reside.
;extension_dir='./'
extension_dir='ext'
Uncomment mysql modules

Save the changes and open a command prompt. Check to make sure it shows loaded modules.

Mysql Php Connect

So now we have Apache running and configured to use php. Lets create a file called info.php, save it and see if Apache parses the info correctly to display the results.

Open Notepad or your favorite Windows editor and type and save the following.

2
phpinfo();

Open your browser and type, localhost/info.php for the location and you should receive alot of information about PHP.

MySQL
Download mysql-installer-community-5.7.18.1.msi. You will also need to install Microsoft Visual C++ VS 2015 x64 from https://www.microsoft.com/en-us/download/details.aspx?id=48145 and Microsoft Visual C++ VS 2013 x64 install first.

Once the installation is completed you can let the configuration wizard run and setup the database server. The defaults will work just fine, but remember what you set the password to for root and create a local user.

At this point you should have a working Apache / PHP / MySQL installation running and ready for you to use!

  1. Brilliant!

    This saved me a lot of time.

    So helpful. Thank you!

  2. Hi

    What should i add at the bottom of httpd.conf file if i download httpd-2.4.29-Win64-VC15 version. Can you please guide me.

    Thanks a lot

  3. Good day, this tutorial is compatible with Windows server 2012 r2 or I need to change something?

    Thank you for you answer and congratulations for your work.

Trackbacks/Pingbacks

  1. Laravel on Windows cannot use MySQL – IlluminateDatabaseQueryException: could not find driver (SQL: select [duplicate] – Mysql Questions - […] the advise in this helpful post I editing my php.ini by uncommenting the following […]

This site uses Akismet to reduce spam. Learn how your comment data is processed.

If you are planning to install Apache, PHP and MySQL on Windows 10 machine, then you can do so by choosing any of the two options given below:

  1. You can use any ready-to-use packages like: WampServer, XAMPP etc.
    OR
  2. You can make your own fully functional WAMP server (Manual Installation).

So, in this tutorial, you’ll learn about how you can install Apache, PHP and MySQL server on your Windows 10 PC manually . As I’m currently using Windows 10 Pro 64-bit, so this tutorial is based upon it. I recommend that you read the whole tutorial first before following the instructions.

First, we have to decide as to which version of each application will be installed.

  • Apache 2.4.29
  • MySQL 5.7.21
  • PHP 7.2.3

You can download the required installer via links given below:

  • Download Apache for Windows: https://www.apachelounge.com/download/
  • Download PHP 7 for Windows (select ‘Thread Safe’): http://windows.php.net/qa/
  • Download MySQL for Windows (select ZIP Archive): http://dev.mysql.com/downloads/mysql/
  • Download the latest C++ Redistributable Visual Studio 2017: https://www.microsoft.com/en-in/download/details.aspx?id=48145
  • Download Visual C++ Redistributable Packages for Visual Studio 2013: https://www.microsoft.com/en-US/download/details.aspx?id=40784

Managed WordPress Hosting

MySQL Installation on Windows 10 Pro 64 bit:

  • Download MySQL installer and click on Run.
  • Select License Agreement and then click on Next.
  • Select Server Only and click on Next.
  • It will ask you to install Visual Studio 2013 on your system.
  • Click on the Execute button.
  • Select License agreement and click on Install.
  • Click on Close.
  • Click on Next.
  • Click on Execute.
  • Click on Next.
  • Click on Next.
  • Put root user password. Confirm password and Click on Next.

  • Click on Next.
  • Click on Next.
  • Click on Finish.

Your MySQL database server is now ready for use. You can use any MySQL client software for managing your database, like phpMyAdmin, Heidi SQL, SQL YOG etc.

Apache 2.4 Installation on Windows 10 Pro 64 bit:

  • Install the latest C++ Redistributable Visual Studio 2017: https://www.microsoft.com/en-in/download/details.aspx?id=48145
  • Download Apache files and unzip them (archive httpd-2.4.25-win64-VC14.zip) to the C:Apache24 directory:
  • After unzipping, go to the folder c:Apache24conf and open the httpd.conf file by any text editor.
  • Change below line in this file:

#ServerName www.example.com:80

ServerName localhost

# AllowOverride controls what directives may be placed in .htaccess files.

# It can be “All”, “None”, or any combination of the keywords:

# AllowOverride FileInfo AuthConfig Limit

#

Carmina burana youtube. AllowOverride None

# AllowOverride controls what directives may be placed in .htaccess files.

# It can be “All”, “None”, or any combination of the keywords:

# AllowOverride FileInfo AuthConfig Limit

#

AllowOverride All

#LoadModule rewrite_module modules/mod_rewrite.so

LoadModule rewrite_module modules/mod_rewrite.so

  • Register Apache service:

If you see this page, it means that your Apache installation has been successfully done.

You can modify index page code or upload your files like example given below.

PHP Installation on Windows10:

Mysql Download For Windows Server

  • Download PHP package php-7.1.1RC1-Win32-VC14-x64.zip and unzip under C:php72
  • Rename php-ini-development.ini to php.ini
  • Add PHP in system environment variable.

C:>setx path “%PATH%, C:php72” /M

  • Again, open the file c:Apache24confhttpd.conf and append it with lines:

PHPIniDir “C:/PHP72”

  • AddHandler application/x-httpd-php .php

LoadModule php7_module “C:/PHP72/php7apache2_4.dll”

  • Restart Apache services.

Now you can access your PHP page from default Apache document root. Here I have created on phpinfo.php page.

That’s it! You’re done 🙂

Managed WordPress Hosting

How To Install Apache Mysql Php On Windows Server 2008

Planning to install Apache, PHP and MySQL? Choose VPS and pick any plan from https://www.znetlive.com/vps-hosting-windows/

Services ZNetLive offer:

If you have any doubt regarding this write-up or need to know more about the installation, drop comments below and get in touch.

Umesh Dubey

Install Mysql Php Windows Server 2012

Umesh, Team Lead - Technical, is a Microsoft products’ expert with enviable certifications like RHCE, MCPS, MCSA and MCSE. An excellent team player, he utilizes his expertise of over 7 years in the technical sphere to handle technical issues brilliantly and dedicatedly value adds to the system administration and management fields. He can be seen drawing or playing chess in free time.

Latest posts by Umesh Dubey (see all)

Install Mysql Php Windows Server Error

  • How to install Let’s Encrypt SSL certificate on IIS web server? - October 16, 2017
  • How to run Hyper-V in a Virtual Machine with Nested Virtualization? - October 4, 2017
  • Step by step tutorial on how to configure SMTP server in Windows server 2016 - October 24, 2016