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.
There are four versions of the XAMPP software bundle: for Linux, Windows, Mac OS X, and Solaris. They're all available from the web site www.apachefriends.org/en/xampp.html. To get started with XAMPP for Mac, go down to XAMPP for Mac OS X and click the link and then download the application. You will find that it's completely free and does not require registration. The application is delivered to you as a DMG file. Double-click the DMG file, and then to install XAMPP, simply drag the folder into the Applications folder.
That will take just a few moments to copy the application over to your Applications folder. Once the copying process is complete, close the Finder window and eject the virtual disk named XAMPP for Mac. Before you start up XAMPP, check to make sure that you don't have any other copies of Apache or MySQL running. I will go to my System Preferences and from there to Sharing, and I'll make sure that my Web Sharing option is deselected.
If you've installed MySQL separately, also make sure that it's stopped. Warning: if you've had MySQL or Apache running in that same session, you might want to shut them down and then reboot your Mac and only then start up XAMPP. Now I've currently got both servers stopped, so I am ready to roll. I will go to my Applications folder, I will go to Finder, and select Go > Applications. From there, I will scroll down to the bottom and locate the XAMPP folder, and here I will find an application called XAMPP Control.
Just as with MAMP and other servers, the web document root where you put your HTML, PHP, and other web files is named htdocs, and you'll find that the folder already has some files that are seeded there for you. Now, I will go back to the XAMPP root folder, and I will start up the Control panel. If prompted, click Open. You'll see that XAMPP opens as two windows: there's a small control panel on the right and an informational screen at the left.
I'll click the Start button for Apache, and if prompted, type my password. I'll click the Start button for MySQL as well. If you see green indicators on Apache and MySQL then you're ready to start using your XAMPP server. There's also an option for starting up an FTP server. I won't use that here. Now, to test my web site, I'll click localhost. That takes me to localhost/xampp/splash.php.
I will click English and now I'm on the XAMPP homepage. From here, you'll be able to set status, control security, look at documentation, and execute a lot of other functionality. The phpinfo command which I've used in some other videos in this course is available from this screen already. When I click phpinfo, I'm shown the version of PHP that I'm running. Now to make sure that MySQL is running, I'll click on phpMyAdmin, which is right here under tools.
If you're able to open phpMyAdmin, you're good to go. Your Apache server is running, your MySQL database server is running, and you're ready to create your own databases. Now again, there are many more options available in XAMPP, and I'll show you some of these in other videos.
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.