Lynda – Installing Apache, MySQL, and PHP

Author: David Gassner
Level: Intermediate | Duration: 2h 31m | Released date: Jan 21, 2011 | Updated: Jul 06, 2012
Homepage: http://www.lynda.com/MySQL-5-tutorials/installing-apache-mysql-and-php/77958-2.html

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), 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

• Introduction
  • Welcome
  • Understanding Apache, MySQL, and PHP
  • Using the exercise files
  • What’s new in this update
• 1. Installing Separate Components on Windows
  • Installing Apache on Windows
  • Starting Apache from the command line
  • Installing PHP with Apache on Windows
  • Installing MySQL on Windows
  • Installing phpMyAdmin on Windows
• 2. Installing Separate Components on Mac OS X
  • Activating Apache on Leopard and Snow Leopard
  • Activating Apache on Lion
  • Activating PHP on Mac OS X
  • Installing MySQL on Mac OS X
  • Setting the root user password
  • Installing phpMyAdmin on Mac OS X
  • Uninstalling MySQL on Mac OS X
• 3. Installing WampServer on Windows
  • Installing WampServer
  • Managing WampServer
  • Defining directory aliases through WampServer
  • Changing software versions with WampServer add-ons
• 4. Installing MAMP on Mac OS X
  • Installing MAMP
  • Configuring Apache and MySQL server ports
  • Managing MAMP
• 5. Installing XAMPP
  • Installing XAMPP for Windows
  • Managing XAMPP for Windows
  • Managing MySQL security through XAMPP for Windows
  • Installing XAMPP for Mac OS X
  • Managing XAMPP for Mac OS X
  • Managing MySQL security through XAMPP
• 6. Installing BitNami
  • Installing BitNami for Windows
  • Installing BitNami for Mac OS X
• 7. Troubleshooting
  • Handling port conflicts with Skype on Windows
  • Handling other port conflicts on Windows
  • Detecting and handling port conflicts on Mac OS X
  • Configuring Apache to work with IPv6 on Windows 8
• Conclusion
  • Goodbye

Download

Download

Download