Camera Operator / Editor

One of the greatest time wasters today has got to be social-networking websites. More specifically, Facebook and Twitter. I found myself spending unnecessary amounts of time on both of those websites during work or when I had nothing else to do. Let’s not lie, it’s an addiction, and many people are guilty of it besides me. Fortunately, there have already been temporary solutions such as SelfControl, a  freeware application developed by Steve Lambert. In the past I used SelfControl because it was simple and allowed me to setup a time frame that I could block out Facebook and/or Twitter. For students, I can almost certainly recommend using that application during finals week or when preparing for any exams in general. However, I wanted to stop frequenting Facebook on my Mac, so I needed a more permanent solution other than deactivating my account because I still want to be able to access Facebook from my iPhone. With a view commands in Terminal, this can be done in no time!

  1. Open up Terminal in /Applications/Utilities.
  2. In the command line, type in "sudo nano /etc/hosts".
  3. When asked, type your admin password.
  4. In the screen that will appear, you’ll see the host database for your computer.
  5. Using your down arrow, go to the bottom, right under where it says, " localhost".
  6. Type in "".
  7. On a new line, type in ""; this is for extra measure.
  8. Now, hold down Control + “O”. This will save the changes to the host database.
  9. Hit “Return” and then Control + “X” to exit the screen.
  10. Remove the existing cache by typing in "sudo dscacheutil -flushcache" in the command line, this refreshes the existing cache on the host database.
  11. You should receive an “Unable to connect” error message when you go to now.
  12. Now, back to doing something more productive…

screenshots: 1 2-3 4-7 10 11

mamp icon

Recently I was working on a website using an eCommerce platform, which requires a database. In a situation like that, where I’ll need PHP and MySQL, I prefer to use MAMP for its simplicity. It’s a great application for the Mac that enables you to setup a local server environment in a matter of seconds. Yet, I came across a rather bothersome problem the other day when I opened up MAMP and noticed a red circle for the “MySQL Server” status, which prohibited me from being able to work on the website. Fortunately, with Activity Monitor or Terminal, there are two very quick solutions to this problem.

Using Terminal

  1. First, if MAMP is currently open, go ahead and quit it.
  2. Open up Terminal from the Utilities folder within Applications.
  3. In the command line, type in "sudo killall mysqld".
  4. Type in your admin password when asked.
  5. If you open MAMP, you should now see two green statuses.

screenshots: 2 3 5

Using Activity Monitor

  1. First, if MAMP is currently open, go ahead and quit it.
  2. Open up Activity Monitor from the Utilities folder in Applications.
  3. Look for “mysqld” under the list of processes currently running.
  4. Select it, and click on the red “Quit Process” button in the top left corner.
  5. Choose “Force Quit” when the drop-down window appears.
  6. Now, when you open MAMP, there will be a green status next to MySQL Server.

screenshots: 2 3 4-5 6