Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
When you install XAMPP for Mac OS X, a lot of the security options are left in an open state. That is your installation of both Apache and MySQL is insecure. There are some fundamental security things you should take care of after the installation. In the Getting Started window click localhost, then if prompted select your language. When you get to the homepage you can click the Security item under the XAMPP menu. On this screen you'll see a summary of your security settings.
For example, your XAMPP pages by default are accessible over the network for everybody. MySQL is also accessible over the network, as opposed to only being available on your local system. There are also passwords for the phpMyAdmin user and for the MySQL root user. To change these settings you'll need to run an application called XAMPP Security. You can run this application from Terminal. Here is a quick and easy way to start it up.
Go to the bottom of the page and select the command to open the application and then copy that command to the clipboard. Now open Terminal and then on the command line I'll start by typing sudo, for super user do. Then I'll type in a space character and then I'll press Command+V to Paste in the command. I'll press Return and that starts up the security application. Depending on your most previous actions and your computer's configuration, you might be prompted at this point for your administrator password.
That's your Mac user password. Type it in and press Return if necessary and then paste in the command again. First I'm asked whether I want to secure my XAMPP pages. If I type Y for Yes, that means that I'll be securing the pages when they requested through the browser. For local development that's a bit of a pain, so I'll type in N and press return. Next, I'm asked whether MySQL should be accessible via the network. Once again, I'll type in N. Next, I'm asked for a phpMyAdmin root user password.
I don't want to set that password because it's going to slow down my development work, so I'll type in N. But here's a password I do want to set. The MySQL root password typically should be set, because even for local development it's a good idea to test a user with a secured account. So I'll type in Y for yes and press Return, then I'll type in a password that I want to use. I'll use this simple string password. I'll type it in once and press Return, then type it again and press Return.
Finally, I'm asked about my FTP server, which I'm not using. So I'll just press Return and that completes the security application. To test the security settings I'll click back on the browser and then refresh the page. I'll click Security again and I'll see my new settings. I'll go to phpMyAdmin and I'll see that I'm prompted for a username. I'll type in root and password. I've successfully opened phpMyAdmin and I can now manage my MySQL Server.
So that's how you can reset your security settings through the Security application. On Mac, once again, it's a command line application that you use through Terminal and you can control whether your MySQL and Apache servers can be accessed over the network and you can reset your administrator passwords.
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.