Installing Apache, MySQL, and PHP Update (2014)

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.

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 UPDATED
Welcome
Understanding Apache, MySQL, and PHP
Using the exercise files
What's new in this update UPDATED
What's new in this update
Choosing a software stack

1. Installing Separate Components on Windows
Installing Apache HTTP 2.2 on Windows
Installing Apache 2.4 on Windows
Starting Apache from the command line
Installing PHP with Apache on Windows
Installing MySQL on Windows UPDATED
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 Apache on Mountain Lion
Configuring personal site folders on Mountain Lion and Mavericks UPDATED
Configuring personal site folders on Mountain 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 UPDATED
Installing MAMP
Configuring Apache and MySQL server ports UPDATED
Configuring Apache and MySQL server ports
Managing MAMP UPDATED
Managing MAMP

5. Installing XAMPP
Installing XAMPP for Windows UPDATED
Installing XAMPP for Windows
Managing XAMPP for Windows
Managing MySQL security through XAMPP for Windows
Installing XAMPP for Mac OS X UPDATED
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 UPDATED
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