navigate site menu

Start learning with our library of video tutorials taught by experts. Get started

Installing Apache, MySQL, and PHP

Installing Apache, MySQL, and PHP

with David Gassner

 


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.
Topics include:
  • Performing Apache, PHP, and MySQL as separate installs
  • Activating Apache and PHP on Leopard, Snow Leopard, and Lion
  • Setting the MySQL root user password
  • Installing WampServer
  • Changing software versions with WampServer add-ons
  • Installing MAMP
  • Configuring MAMP's Apache and MySQL server ports
  • Installing XAMPP for Windows and Mac
  • Managing MySQL security through XAMPP
  • Installing Bitnami for Windows and Mac
  • Detecting and handling port conflicts
  • Working with Apache and IPV6 in Windows 8

show more

author
David Gassner
subject
Developer, Web, Servers, Databases
software
MySQL , PHP , HTTP Server , Apache HTTP Server
level
Intermediate
duration
2h 43m
released
Jan 21, 2011
updated
Jan 09, 2013

Share this course

Ready to join? get started


Keep up with news, tips, and latest courses.

submit Course details submit clicked more info

Please wait...

Frequently asked questions

Find answers to the most frequently asked questions about Installing Apache, MySQL, and PHP.




Q: I followed the procedure in the "Installing XAMP for Windows" video, but 1) I got no text file popup after install, and 2) the Admin button does not bring up phpMyAdmin page. Nothing happens even though the Running button is green.

A: The text window not popping up after the installation is just a difference in the installation flow; it shouldn't cause any functional problems.

The issue around phpMyAdmin not opening correctly from the Xampp Control Panel has come up before. There is a bug in the newest version of Xampp for Windows (version 1.7.4) that affects the Control Panel. After starting the Control Panel, and then starting both Apache and MySQL, clicking the MySQL Admin button doesn't open the browser to the phpMyAdmin as expected. However, both MySQL and phpMyAdmin are working correctly.

Follow these steps instead:
  1. Click the Admin button next to Apache to open the Xampp home page in the browser.
  2. Click phpMyAdmin under the Tools section of the menu on the left side of the page.
phpMyAdmin should open correctly. From that point, you should be able to manage your database.
Q: I'm using TextWrangler on the Mac to uncomment the following line in the httpd.conf file, as shown in the video "Activating PHP with the included Apache server" in Chapter 2:

LoadModule php5_module libexec/apache2/libphp5.so

When I try to save the changes, I get the message "Error code: -5000". What's going wrong?
A: This is a common issue with the latest version of TextWrangler. Here's another way of editing the file with a command line editor named Pico that's included in Mac OS X. Remember, most text editors don't give you the ability to edit files as the "root user", and you need those rights to edit the httpd.conf file.

Unlike TextWrangler, Pico doesn't accept mouse input, so you have to do everything with the keyboard:
  1. Open Terminal from /Applications/Utilities/Terminal.
  2. Type sudo pico /private/etc/apache2/httpd.conf.
  3. Type your password and press Return.
  4. Press Ctrl+W for 'Where is'.
  5. Type 'php' and press Return. You should find the commented-out line with php5_module
  6. Delete the '#' at the beginning of the line.
  7. Press Ctrl+X for 'Exit'.
  8. Press Y for 'Yes'.
  9. Press Return to save and exit
We recommend also using Pico to edit the php.ini file.
Q: After downloading XAMPP I was unable to start Apache from the control panel. MySQL started fine. When I click the Start button next to Apache it looks like it starts and then stops. Here is the output:

Busy
Apache Started (Port 80)

The MySQL button says "running" with a stop button; the Apache button still? says start no matter how many time I click it.
A: This usually means that another program is using Port 80 (the port that Apache needs). Port 80 is used for any web server, so you either have another web server running or you're running something else (usually Skype) that is using Port 80.

If you're running Skype (and this is really common), you need to configure it to use a different port. If it's not Skype, it may be that you're running another web server or IIS (Microsoft Internet Information Server, the web server that comes with Windows), which you'll need to quit.
Q: This course was updated on 07/06/2012. What changed?
A: A few of the WampServer movies were updated to reflect the new user interface. We also added movies on installing Bitnami, an open source stack solution, and troubleshooting Apache to work with IPV6 on Windows 8.
Q: This course was updated on 01/09/2012. What changed?
A: Two new movies were added to Chapter 2, "Installing Separate Components on Mac OS X," to reflect the changes in the latest version of Mac OS X, Mountain Lion (version 10.8). These movies cover activating Apache and configuring personal site folders in Mountain Lion.

Can’t find an answer?

If you still have a question about Installing Apache, MySQL, and PHP, let us know.

ask a question

Suggested courses to watch next:

MySQL Essential Training (2h 46m)
Bill Weinman



Are you sure you want to delete this bookmark?

cancel

Bookmark this Tutorial

Name

Description

{0} characters left

Tags

Separate tags with a space. Use quotes around multi-word tags. Suggested Tags:
loading
cancel

bookmark this course

{0} characters left Separate tags with a space. Use quotes around multi-word tags. Suggested Tags:
loading

Error:

go to playlists »

Create new playlist

name:
description:
save cancel

You must be a lynda.com member to watch this video.

Every course in the lynda.com library contains free videos that let you assess the quality of our tutorials before you subscribe—just click on the blue links to watch them. Become a member to access all 104,141 instructional videos.

get started learn more

If you are already an active lynda.com member, please log in to access the lynda.com library.

Get access to all lynda.com videos

You are currently signed into your admin account, which doesn't let you view lynda.com videos. For full access to the lynda.com library, log in through iplogin.lynda.com, or sign in through your organization's portal. You may also request a user account by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.

Get access to all lynda.com videos

You are currently signed into your admin account, which doesn't let you view lynda.com videos. For full access to the lynda.com library, log in through iplogin.lynda.com, or sign in through your organization's portal. You may also request a user account by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.

Access to lynda.com videos

Your organization has a limited access membership to the lynda.com library that allows access to only a specific, limited selection of courses.

You don't have access to this video.

You're logged in as an account administrator, but your membership is not active.

Contact a Training Solutions Advisor at 1 (888) 335-9632.

How to access this video.

If this course is one of your five classes, then your class currently isn't in session.

If you want to watch this video and it is not part of your class, upgrade your membership for unlimited access to the full library of 2,025 courses anytime, anywhere.

learn more upgrade

You can always watch the free content included in every course.

Questions? Call Customer Service at 1 1 (888) 335-9632 or email cs@lynda.com.

You don't have access to this video.

You're logged in as an account administrator, but your membership is no longer active. You can still access reports and account information.

To reactivate your account, contact a Training Solutions Advisor at 1 1 (888) 335-9632.

Need help accessing this video?

You can't access this video from your master administrator account.

Call Customer Service at 1 1 (888) 335-9632 or email cs@lynda.com for help accessing this video.

preview image of new course page

Try our new course pages

Explore our redesigned course pages, and tell us about your experience.

If you want to switch back to the old view, change your site preferences from the my account menu.

Try the new pages No, thanks

site feedback

Thanks for signing up.

We’ll send you a confirmation email shortly.


By signing up, you’ll receive about four emails per month, including

We’ll only use your email address to send you these mailings.

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

By signing up, you’ll receive about four emails per month, including

We’ll only use your email address to send you these mailings.

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked