Installing Apache, MySQL, and PHP

1h 52mBeginner2020-01-21

Authors

David Gassner

Author of 60+ video-based training courses for software developers

Course details

This course describes how to install and configure Apache HTTP Server, MySQL database server, and PHP, known collectively as the AMP stack, on a local development computer. David Gassner covers different installation approaches, including installing the components separately on Windows, macOS, and Linux and installing the prepackaged WampServer and MAMP bundles. Plus, learn how to troubleshoot port conflicts and other AMP-related issues.

Topics include:
- Installing Apache on Windows
- Working with PHP on Windows and macOS
- Installing MySQL on Windows and macOS
- Starting and stopping Apache on macOS
- Installing Apache, PHP, and MySQL on Ubuntu Linux
- Installing and managing WampServer
- Defining WampServer directory aliases
- Installing MAMP on macOS
- Configuring Apache and MySQL server ports on MAMP
- Handling port conflicts on Windows and macOS
- Resetting the root admin password for MySQL

Skills covered

MySQLPHPApacheLinuxFull-Stack Web DevelopmentDatabase DevelopmentDatabase ManagementWeb DevelopmentProgramming LanguagesOpen SourceSoftware DevelopmentOne-Off

Concepts

0. Introduction

01 - Install, configure, and set up the AMP stack
02 - Who this course is for
03 - What's new in this version of the course

1. Understanding the AMP Stack

04 - What is an AMP stack
05 - Choose a software stack

2. Install Separate Components on Windows

06 - Install Apache on Windows
07 - Configure and run Apache on Windows
08 - Run Apache as a Windows service
09 - Install PHP with Apache on Windows
10 - Install MySQL on Windows
11 - Use MySQL Workbench on Windows
12 - Uninstall MySQL on Windows

3. Install WampServer on Windows

13 - Install WampServer
14 - Manage WampServer
15 - Define WampServer directory aliases

4. Install Separate Components on macOS

16 - Start and stop Apache on macOS
17 - Configure personal site folders
18 - Activate PHP on macOS
19 - Install MySQL on macOS
20 - Install MySQL Workbench on macOS
21 - Uninstall MySQL on macOS

5. Install MAMP on macOS

22 - Install MAMP on macOS
23 - Configure MAMP server ports
24 - Switch MAMP PHP versions
25 - Uninstall MAMP

6. Install LAMP on Linux

26 - Install Apache on Ubuntu Linux
27 - Install PHP on Ubuntu Linux
28 - Install MySQL on Ubuntu Linux
29 - Install MySQL Workbench on Ubuntu Linux

7. Common Tasks and Troubleshooting

30 - Diagnose port conflicts on Windows
31 - Diagnose port conflicts on macOS
32 - Reset MySQL root admin password

Conclusion

33 - Where to go from here