2h 59m – Intermediate
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
Introduction – 17m 35s
Welcome – 1m 9s
Understanding Apache, MySQL, and PHP – 7m 12s
Using the exercise files – 1m 7s
What’s new in this update – 3m 35s
Choosing a software stack – 4m 32s
1. Installing Separate Components on Windows – 30m 18s
Installing Apache HTTP Server 2.4 on Windows – 6m 51s
Installing PHP 5.5 on Windows – 4m 12s
Starting Apache from the command line – 5m 24s
Installing MySQL on Windows – 7m 24s
Installing phpMyAdmin on Windows – 6m 27s
2. Installing Separate Components on Mac OS X – 44m 5s
Activating Apache on Leopard and Snow Leopard – 3m 35s
Activating Apache on Lion – 5m 9s
Activating Apache on Mountain Lion and Mavericks – 4m 57s
Configuring personal site folders on Mountain Lion and Mavericks – 6m 59s
Activating PHP on Mac OS X – 6m 12s
Installing MySQL on Mac OS X – 3m 59s
Setting the root user password – 2m 28s
Installing phpMyAdmin on Mac OS X – 6m 16s
Uninstalling MySQL on Mac OS X – 4m 30s
3. Installing WampServer on Windows – 14m 35s
Installing WampServer – 6m 25s
Managing WampServer – 2m 2s
Defining directory aliases through WampServer – 2m 55s
Changing software versions with WampServer add-ons – 3m 13s
4. Installing MAMP on Mac OS X – 10m 58s
Installing MAMP – 4m 6s
Configuring Apache and MySQL server ports – 1m 57s
Managing MAMP – 4m 55s
5. Installing XAMPP – 29m 3s
Installing XAMPP for Windows – 10m 0s
Managing XAMPP for Windows – 4m 4s
Managing MySQL security through XAMPP for Windows – 2m 40s
Installing XAMPP for Mac OS X – 6m 14s
Managing XAMPP for Mac OS X – 2m 27s
Managing MySQL security through XAMPP – 3m 38s
6. Installing BitNami – 13m 20s
Installing BitNami for Windows – 6m 31s
Installing BitNami for Mac OS X – 6m 49s
7. Troubleshooting – 18m 49s
Handling port conflicts with Skype on Windows – 2m 37s
Handling other port conflicts on Windows – 5m 19s
Detecting and handling port conflicts on Mac OS X – 6m 26s
Configuring Apache to work with IPv6 on Windows 8 – 4m 27s
Conclusion – 31s
Goodbye – 31s