Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 98992 Viewers
80 Video lessons · 141735 Viewers
59 Video lessons · 60084 Viewers
52 Video lessons · 73243 Viewers
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.