Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
Installing Apache, MySQL, and PHP with David Gassner describes how to install and configure Apache HTTP server, MySQL database server, and PHP, known as the AMP stack, on a local development computer. Chapters are devoted to multiple installation approaches: installing the components separately on both Windows and Mac (including coverage of Apache and PHP on Mac OS X 10.7 Lion and 10.8 Mountain Lion), installing the pre-packaged Apache and MySQL distributions in WampServer on Windows and MAMP on Mac, and installing the cross-platform XAMPP and Bitnami on both Mac and Windows. Exercise files are included with the course.
This course was updated on 07/06/2012.
In this course, I'm describing how to install a variety of AMP Stack software packages, but as a software developer, you only need one AMP Stack. So, one of the common questions, is how do I choose? Do I go with the individual components that are available for Windows and OS 10 or do I choose one of the prepackaged bundles; such as Wamp Server for Windows, MAMPP for OS 10 or XAMP or Bitnami, which are available for both operating systems. Here are some of the questions you can ask.
First, if you want complete control over your installation, you might choose to go with the individual components. On Windows, you'll need to get each individual component from the appropriate vendor. You'll the Apache HTTP server from Apache, MySQL from MySQL, and PHP from PHP. And you'll be responsible for all the installation and configuration. On Mac OS X, you can use the included Apache HTTP server and PHP.
They're included in your OS X installation but have to be activated, and I'll show you how to do that in this course. You'll still need to get MySQL from mysql.com. But if you choose this route, you'll be responsible for all the configuration and integration between these products. It's a great way to make sure that you're using the default configuration, and not choosing something that's already been integrated by a third party. For others, the priority will be a fast installation, getting up and running with an AMP stack as quickly as possible.
In my experience, these are the fastest installers on each operating system. On Windows, I recommend WampServer. It includes PHP MyAdmin, the web application you use to manage your MySQL databases, and the AMP stack itself, and little else. For OSX, I recommend MAMP. Again, it includes phpMyAdmin and very little else, but both of these packages install quickly and easily and will help you get up and running as fast as possible. For other developers, the priority might be including more software in the installation.
And in that case, I recommend Bitnami, for both Windows and Mac. The Bitnami server includes both phpMyAdmin, as do all of these AMP stacks, but also includes optional MVC frameworks, such as the Zen framework, CakePHP and many others. For some developers, wrestling with a patchy MySQL ports is a priority. Products like WampServer and Xampp install with the standard ports automatically. Port 80 for Apache, and port 3306 for MySQL.
But other AMP stacks install with other ports. This is mostly an issue on OS X. For example, MAMP starts with non-standard ports, but it's easy to reconfigure. And I'll show you how to do that during the course. The Bitnami OS X stack, on the other hand, sets the port at 8080 for Apache unless you install it as a root user. So again, if this is your priority, using standard ports, look at WampServer, XAMPP on Windows or Mac, and Bitnami on Windows.
Before you install any of these AMP stacks, remember this critical thing on any particular computer that's running server software each port can be used by only one application at a time, so you can only have one copy of the Apache HTTP server listening on port 80. You could have one copy listening on port 80 and another one on 8080, that's fine. But if you try to run two copies of Apache at the same time, listening on the same port, the second one will fail to start.
And it's sometimes hard to diagnose this. I include some troubleshooting tips around this problem, for both Windows and Mac, toward the end of the course. To be on the safe side, before you install an AMP stack, uninstall or completely deactivate all the other AMP stacks on your computer, and make sure nothing is listening on port 80 or port 3306. And again, I have some tips later in the course that describe how to do that. If you're working with Apache MySQL and PHP, there are many ways to get started with a local installation.
So, you can either watch this entire course, and make a choice at the end. Or if you already know which AMP stack you want to use, you can jump to that chapter, and watch just those movies. Either way, I hope this course helps you get started installing your own local AMP stack.
Find answers to the most frequently asked questions about Installing Apache, MySQL, and PHP.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.