I will install wamp server on windows 7 environment which will ultimately leads to the configurations and installation of Apache, PHP, MySql and phpMyAdmin. We will end up to the following applications at the tail of this tutorial. Install and Configure MySQL for PHP Applications on IIS 7.; 5 minutes to read Contributors. In this article. By Ruslan Yakushev. While Microsoft® SQL Server® 2008 is the recommended database to use when hosting PHP applications on an Internet Information Services 7 (IIS 7) and above Web server, you can also use MySQL as the database.

• How To Setup Phpmyadmin On Windows 7
• Install Php Mysql Phpmyadmin Windows 7
• Install Apache Php Mysql And Phpmyadmin On Windows 7
• How To Install Phpmyadmin On Windows 7

How do I install Apache with PHP support and the MySQL server on Windows without using any ready-to-use packages like WAMPServer or XAMPP ?

2 Answers

First, I recommend you read the Platform Specific Notes of Apache for Windows - it explains some Windows-specific features like running as a service that you don't have on other OSes and you probably have never used before.

As mentioned in these platform specific notes, Apache doesn't provide binaries for Windows, however they have links to several third-party sites that provide binaries, for example Apache Lounge.

How To Setup Phpmyadmin On Windows 7

From that website, we can download either the 32-Bit version (win32) or the 64-Bit one (Win64) - if your OS is 64-Bit you should always try to install 64-Bit versions of software, but note that you'll need to use 64-Bit modules as well, that means if you only have a 32-Bit module then download the 32-Bit Apache.

Here's the version that I used when writing this : Apache 2.4.10 Win64. The latest version when this answer was last updated: Apache 2.4.38 Win64 (look at the edit date at the bottom of the post).

Once downloaded, just extract the Apache24 folder to the root of your hard drive, so that you have a path like C:Apache24bin.

Open a command line window (Windows+R and type cmd then press Enter), change directory into C:Apache24bin and run httpd.exe, normally it shouldn't print any errors.

If you get an error dialog stating that MSVCR110.dll is missing on your system, you'll need to install the Visual C++ Redistributable for Visual Studio 2012 - as always, when prompted, select the appropriate bit-version : vcredist_x86.exe for 32-Bit systems and vcredist_x64.exe for 64-Bit ones.

If you get an error saying that it can't bind to port 80, check if another application uses that port - also Skype is known to use ports 80 and 443 by default; uncheck 'Use port 80 and 443 as alternatives for incoming connections' in its advanced connection settings, restart Skype to apply the changes, and then you should be able to start Apache without issues.

A warning like Could not reliably determine the server's fully qualified domain name can be ignored for now.

Windows Firewall may prompt you to allow Apache to communicate on specific networks, I recommend you use the default settings : allow it on home and work networks, but not on public/untrusted networks.

Then, open a browser and browse to http://localhost, if you see a page saying It works ! then it means your Apache installation is working.

You can now stop the currently running Apache by pressing Ctrl+C in the command prompt.

If you got a warning about not being able to determine the system's fully qualified domain name, fix it by editing C:Apache24confhttpd.conf and editing the ServerName variable (it should be already there in a comment, just uncomment it and change it) :

Replace <yourhostname> with either the system's host name or localhost.

Finally, if you want to run the server automatically when the system starts (even if nobody logs in), you'll need to run it as a service - in a new elevated (as an administrator) command prompt, type :

That's it, now you have a new service in Services (Windows+R then type 'services.msc' then press Enter) named 'Apache2.4' that you can control just like any other Windows service.

Restricting Apache access to localhost only - optional

If you're setting this up for development purposes you want to make sure that no one except you can access it, your firewall should already take care of that but let's add another layer of security to it by telling Apache to accept requests from the local machine only.

Open Apache's configuration file C:Apache24confhttpd.conf, search for the default directory block <Directory 'c:/Apache24/htdocs'>.

At the end if it, there should be a line Require all granted, this means that anyone can access this server. Let's make that Require local which only allows access from the local machine.

Also, you can tell Apache to only bind to the loopback interface, that way even if both your firewall and the access control directives mentioned above fail, the server still won't be open to the whole internet.

For this, locate the Listen directive (by default it's set to 80) and change it to the following :

The first line is self explanatory, the second one is the first one's IPv6 equivalent, the brackets are used in the IPv6 notation to separate the address and the port.

Save the file, if you're already running the server then restart it in order to take our changes into account, and now only localhost has access, everyone else will get a 403 Forbidden.

I suggest you read the official PHP documentation about installing it on Windows systems.

Download the latest PHP binaries from the official PHP for Windows download page, choose the thread-safe version that matches your Apache installation's bit-version (x86 for 32-Bit, x64 for 64-Bit).

The non thread-safe version is only when running as a CGI binary - more info here.

The version I used is this : PHP 5.6.2 VC11 x64 Thread Safe. The latest version when this answer was last updated: PHP 7.3.3 VC15 x64 Thread Safe (look at the edit date at the bottom of the post).

Create an empty PHP folder at the root of your hard drive, and extract the previously downloaded archive there, you should have a path like C:PHPext, otherwise you did something wrong.

In C:PHP, rename the php.ini-production or php.ini-development (depending on what you want) to php.ini.

Open that php.ini file, search for extension_dir = 'ext' and uncomment that line (remove the first ;). This sets the default extension dir to ext (which resolves to C:PHPext and avoids having to prepend ext/ to all extension's paths manually like in previous versions of this post.

Now configure Apache to use that PHP, by editing C:Apache24confhttpd.conf - after all the LoadModule lines, add the following :

(The follow is for PHP 7 only)

(The following is for PHP 5 only)

Now try to start Apache manually by opening a command prompt in C:Apache24bin and running httpd.exe - if you see no errors, it means your configuration file is valid and PHP is most likely working.

You can test your PHP installation by creating a file like info.php with <?php phpinfo(); inside and going to http://localhost/info.php - you should see quite a bit of info about your system and your PHP installation and all its modules. If you get something else like an 'Internal server error' that means something's wrong.

You can now kill your current Apache process (Ctrl+C in the console) and start the service - the following part doesn't interact with Apache and can be done with the server already started.

Composer - optional

Composer is a tool for dependency management in PHP, like a package manager. It allows to easily install PHP packages and even entire frameworks.

Composer requires the PHP OpenSSL extension to be enabled, so let's enable it in C:PHPphp.ini.

Use your text editor's search function to search for php_openssl.dll, there should already be a commented line for it, just uncomment that line.

Now download Composer's Windows installer from their download page - or just use this direct link.

Follow the instructions, when prompted for the path to PHP, browse to C:PHP and select php.exe.

That's it, Composer is now installed system-wide and can be used from anywhere - you can try it out, just open a new command prompt (you can't use one that's already open since it needs to read the new PATH variable set by Composer's installer) and type composer.

You should get a nice ASCII-art logo and something like this :

PHP MySQL extensions - optional

If you want to access your MySQL database from PHP, you'll need to enable extensions that allow you to do so, like php_mysqli or php_pdo_mysql - I recommend enabling them both.

Open PHP's configuration file C:PHPphp.ini in your text editor and search for php_mysqli or php_pdo_mysql - they should already be there, uncomment them.

Done, now you can access any MySQL database using either mysqli or PDO.

On the MySQL Installer download page download the web installer mysql-installer-web-community-xxxxx.msi.

I used mysql-installer-web-community-5.6.21.1.msi. The latest version when this answer was last updated: mysql-installer-web-community-8.0.15.0.msi (look at the edit date at the bottom of the post).

The installer will automatically install the appropriate version (32-Bit or 64-Bit) depending on your system, even though MySQL's bit version doesn't have to match Apache's and PHP's one but it's still beneficial to use the 64-bit version of your system supports it to take advantage of more than 3 GB of RAM, that's quite important as database servers tend to use a lot of RAM.

Follow the steps in the installer, if you're installing this for development then the Developer default will be your best option, it'll also install MySQL Workbench which is a native GUI client, thus avoiding you having to install slow web-based tools such as PHPMyAdmin if you aren't comfortable with using the command line client.

Once everything is installed the installer will ask your for some basic configuration values, I recommend disabling 'Open firewall port for network access' unless you want to access the database from another machine on the network.

Set the root password - if it's only for development purposes and your firewall blocks incoming connections from the network then a strong password isn't necessary.

Finally, you can disable the useless MySQL Notifier by right-clicking the tray icon, going into Actions -> Options, then untick the Run at Windows Startup checkbox and apply. That'll save you a few MBs of RAM and avoid slowing your machine down when it's booting.

And that's it, you now have a fully functional WAMP server that runs as a service and doesn't depend on any user (accessible even if no one is logged in).

Note that I have no idea about the security of this, for development purposes I'd say this is pretty safe since your firewall should block incoming connections for both Apache (port 80 and or 443) and MySQL (port 3306).

This was tested on a Windows 7 installation, it should also work just fine on Vista, Windows 8 and possibly Windows Server 2008/2012 - feel free to comment and/or downvote if that's not the case.

The instructions in the above answer work perfectly as of July 2017, however, if you wish to use PHP 7, you must add the following lines to C:Apache24confhttpd.conf, instead of the ones in that answer (which work only for PHP 5) [Add the following after all the LoadModule lines]:

Ensure that all paths are correct. If you don't have php7apache2_4.dll in your PHP directory, you probably downloaded the wrong package.

rahuldottech

Install Php Mysql Phpmyadmin Windows 7

rahuldottech

protected by Mokubai♦Jul 2 '16 at 21:59

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?

[+/-]

2.3.1 MySQL Installation Layout on Microsoft Windows

2.3.2 Choosing an Installation Package

2.3.3 MySQL Installer for Windows

2.3.4 Installing MySQL on Microsoft Windows Using anoinstall ZIP Archive

2.3.5 Troubleshooting a Microsoft Windows MySQL Server Installation

2.3.6 Windows Postinstallation Procedures

2.3.7 Windows Platform Restrictions

Install Apache Php Mysql And Phpmyadmin On Windows 7

MySQL Community 5.7 Server requires the Microsoft Visual C++ 2013 Redistributable Package to run on Windows platforms. Users should make sure the package has been installed on the system before installing the server. The package is available at the Microsoft Download Center.

MySQL is available for Microsoft Windows, for both 32-bit and 64-bit versions. For supported Windows platform information, see https://www.mysql.com/support/supportedplatforms/database.html.

If your operating system is Windows 2008 R2 or Windows 7 and you do not have Service Pack 1 (SP1) installed, MySQL 5.7 will regularly restart and in the MySQL server error log file you will see this message:

This error message occurs because you are also using a CPU that does not support the VPSRLQ instruction and indicates that the CPU instruction that was attempted is not supported.

To fix this error, you must install SP1. This adds the required operating system support for the CPU capability detection and disables that support when the CPU does not have the required instructions.

Alternatively, install an older version of MySQL, such as 5.6.

There are different methods to install MySQL on Microsoft Windows.

MySQL Installer Method

The simplest and recommended method is to download MySQL Installer (for Windows) and let it install and configure all of the MySQL products on your system. Here is how:

1. Download MySQL Installer from https://dev.mysql.com/downloads/installer/ and execute it.

   Unlike the standard MySQL Installer, the smaller 'web-community' version does not bundle any MySQL applications but it will download the MySQL products you choose to install.

2. Choose the appropriate Setup Type for your system. Typically you will choose Developer Default to install MySQL server and other MySQL tools related to MySQL development, helpful tools like MySQL Workbench. Or, choose the Custom setup type to manually select your desired MySQL products.

   Multiple versions of MySQL server can exist on a single system. You can choose one or multiple versions.

3. Complete the installation process by following the instructions. This will install several MySQL products and start the MySQL server.

MySQL is now installed. If you configured MySQL as a service, then Windows will automatically start MySQL server every time you restart your system.

You probably also installed other helpful MySQL products like MySQL Workbench and MySQL Notifier on your system. Consider loading Chapter 30, MySQL Workbench to check your new MySQL server connection, and MySQL Notifier Overview to view the connection's status. By default, these two programs automatically start after installing MySQL.

This process also installs the MySQL Installer application on your system, and later you can use MySQL Installer to upgrade or reconfigure your MySQL products.

Additional Installation Information

It is possible to run MySQL as a standard application or as a Windows service. By using a service, you can monitor and control the operation of the server through the standard Windows service management tools. For more information, see Section 2.3.4.8, “Starting MySQL as a Windows Service”.

How To Install Phpmyadmin On Windows 7

Generally, you should install MySQL on Windows using an account that has administrator rights. Otherwise, you may encounter problems with certain operations such as editing the PATH environment variable or accessing the Service Control Manager. When installed, MySQL does not need to be executed using a user with Administrator privileges.

For a list of limitations on the use of MySQL on the Windows platform, see Section 2.3.7, “Windows Platform Restrictions”.

In addition to the MySQL Server package, you may need or want additional components to use MySQL with your application or development environment. These include, but are not limited to:

• To connect to the MySQL server using ODBC, you must have a Connector/ODBC driver. For more information, including installation and configuration instructions, see MySQL Connector/ODBC Developer Guide.

  MySQL Installer will install and configure Connector/ODBC for you.

• To use MySQL server with .NET applications, you must have the Connector/NET driver. For more information, including installation and configuration instructions, see MySQL Connector/NET Developer Guide.

  MySQL Installer will install and configure MySQL Connector/NET for you.

MySQL distributions for Windows can be downloaded from https://dev.mysql.com/downloads/. See Section 2.1.2, “How to Get MySQL”.

Lexmark x422 printer driver windows 7 download preactivated version. Lexmark X422 Windows Driver Details File Name: Lexmark_Network_TWAIN_scan.exe Released: Version: 1.15 File Size: 13.19 MB Operating Systems: Windows 7 (64-bit), Windows 7 (32-bit), Windows 8 (32-bit), Windows 8 (64-bit), Windows 8.1 (32-bit), Windows 8.1 (64-bit), Windows Vista (32-bit), Windows Vista (64-bit), Windows XP (32-bit), Windows XP Professional (64-bit) Lexmark X422 Mac Driver Details File Name: X422_Print_1.0.0_10.6orLater_forIntel.dmg Released Version: 1.0.0 File Size: 4.4 MB Operating Systems: Mac OS X 10.8, Mac OS X 10.9, Mac OS X 10.6, Mac OS X 10.7. Lexmark X422 driver and software for setting up, configuring, and using your device with Windows and Macintosh.

MySQL for Windows is available in several distribution formats, detailed here. Generally speaking, you should use MySQL Installer. It contains more features and MySQL products than the older MSI, is simpler to use than the compressed file, and you need no additional tools to get MySQL up and running. MySQL Installer automatically installs MySQL Server and additional MySQL products, creates an options file, starts the server, and enables you to create default user accounts. For more information on choosing a package, see Section 2.3.2, “Choosing an Installation Package”.

• A MySQL Installer distribution includes MySQL Server and additional MySQL products including MySQL Workbench, MySQL Notifier, and MySQL for Excel. MySQL Installer can also be used to upgrade these products in the future.

  For instructions on installing MySQL using MySQL Installer, see Section 2.3.3, “MySQL Installer for Windows”.

  View and Download HP W1907 - 19'' LCD Monitor user manual online. Flat Panel Monitor. W1907 - 19'' LCD Monitor Monitor pdf manual download. Also for: F1903. W1907 LCD Monitor w2007 LCD Monitor w2207 LCD Monitor w2216 LCD Monitor. Vi User’s Guide 4 Operating the Monitor. User’s Guide 1–1 1 Product Features HP LCD Monitors The HP LCD (liquid crystal display) monitors have an active matrix, thin-film transistor (TFT) screen. Easily find and download software and drivers for your HP products including pcs, laptops, desktops, printers, tablets, apps and services from HP Customer Support. HP w1907 19-inch Widescreen LCD Monitor. Choose a different product. HP Pavilion w1907 Monitor - Product Specifications This document applies to the HP Pavilion w1907 monitor. The HP Pavilion w1907 is a 19-inch wide-screen flat panel monitor with liquid crystal display (LCD) and thin-film transistor (TFT) screen. Hp W1907 Pdf User Manuals. View online or download Hp W1907 User Manual, Quick Start. Manual for hp w1907 monitor.

• The standard binary distribution (packaged as a compressed file) contains all of the necessary files that you unpack into your chosen location. This package contains all of the files in the full Windows MSI Installer package, but does not include an installation program.

  For instructions on installing MySQL using the compressed file, see Section 2.3.4, “Installing MySQL on Microsoft Windows Using a noinstall ZIP Archive”.

• The source distribution format contains all the code and support files for building the executables using the Visual Studio compiler system.

  For instructions on building MySQL from source on Windows, see Section 2.9, “Installing MySQL from Source”.

MySQL on Windows Considerations

• Large Table Support

  If you need tables with a size larger than 4 GB, install MySQL on an NTFS or newer file system. Do not forget to use MAX_ROWS and AVG_ROW_LENGTH when you create tables. See Section 13.1.18, “CREATE TABLE Syntax”.

  InnoDB tablespace files cannot exceed 4 GB on Windows 32-bit systems.

• MySQL and Virus Checking Software

  Virus-scanning software such as Norton/Symantec Anti-Virus on directories containing MySQL data and temporary tables can cause issues, both in terms of the performance of MySQL and the virus-scanning software misidentifying the contents of the files as containing spam. This is due to the fingerprinting mechanism used by the virus-scanning software, and the way in which MySQL rapidly updates different files, which may be identified as a potential security risk.

  After installing MySQL Server, it is recommended that you disable virus scanning on the main directory (datadir) used to store your MySQL table data. There is usually a system built into the virus-scanning software to enable specific directories to be ignored.

  In addition, by default, MySQL creates temporary files in the standard Windows temporary directory. To prevent the temporary files also being scanned, configure a separate temporary directory for MySQL temporary files and add this directory to the virus scanning exclusion list. To do this, add a configuration option for the tmpdir parameter to your my.ini configuration file. For more information, see Section 2.3.4.2, “Creating an Option File”.

• Running MySQL on a 4K Sector Hard Drive

  Running the MySQL server on a 4K sector hard drive on Windows is not supported with innodb_flush_method=async_unbuffered, which is the default setting. The workaround is to use innodb_flush_method=normal.