Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
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.
The XAMPP installation includes a couple of useful management tools that will help you administer your servers. First, make sure that your servers are running through the Controls dialog and then go to your Getting Started window and click the localhost link. That will take you to the homepage. On the homepage take a look at phpinfo(). This is a simple page that outputs the configuration of your PHP server. The most important bit of information on this screen is the Loaded Configuration File.
That's the location of the php.ini file that's managing your PHP installation. The default location is /Applications/XAMPP/xamppfiles/etc/php.ini. You can also open phpMyAdmin. Click phpMyAdmin under Tools. If you see the Prompt screen just click Go. Assuming you haven't set up a root user password on your MySQL installation, you should be able to go to phpMyAdmin instantly.
You'll see over on the left that the installation of MySQL with XAMPP for Mac includes a number of databases, including the test database, a simple beginning database where you can add new tables and do some testing of some data. I'll go back to the main window and also show you that there are some sample applications that you might find useful. For example, the Phonebook application lists three names. This is an application that's built with PHP and SQLite, a very simple database much simpler and lighter than MySQL that's included with the XAMPP installation as well.
I'll type in a value of Smith for the Last name, John for the First name, and then a fake phone number. Then I'll click Add and it'll show that the data has been added to the database. Click Show source code down toward the bottom and you will be able to scroll down and take a look at the PHP code that's executing this little application. There are some other useful sample applications you can explore as well. So that's a look at the sample applications and administrative tools that are included with XAMPP for Mac OS X. One other important application is used to manage the security of your XAMPP installation.
I'll describe how to use this feature in the next video.
Find answers to the most frequently asked questions about Installing Apache, MySQL, and PHP.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.