is now LinkedIn Learning!

To access courses again, please join LinkedIn Learning

All the same content you know and love

Plus, personalized course recommendations tailored just for you

All the same access to your Lynda learning history and certifications

Try LinkedIn Learning for free
Questions? Visit our help center.
Skip navigation

SQL Essential Training (2014)

Welcome: SQL Essential Training (2014)
Welcome: SQL Essential Training (2014)
Skill Level Beginner
3h 27m
Show More Show Less
Resume Transcript Auto-Scroll

Q: For Mac OS X: When I try to start the Apache Web Server from the XAMPP control panel, it doesn't start, and when I open "localhost" in my web browser, I see a white screen that says "It Works!" instead of the XAMPP page.

A: This usually means that you have the Apple version of the Apache Web Server already running.
Apple provides a version of the Apache Web Server with OS X. I chose to use XAMPP because it includes PHP and the MySQL server all in one package.
You cannot install XAMPP with Apache already running on your Mac. If you see "It works!" when you open your browser and type "localhost" into the address bar, this means that the Apple version of Apache is already running. You cannot run two instances of a web server at once, so the Apple Apache must be stopped before you can install XAMPP.
In OSX 10.7 and earlier, you could start and stop the Apache Web Server in Control Panel, by choosing "Sharing" and then unchecking the "Web Sharing" checkbox. As of 10.8 this option is no longer in the control panel.
To disable Apple's version of Apache in current versions of OS X, open a Terminal window and type this command:
sudo apachectl stop
You will need to type your system password when prompted, then you should be able to start the XAMPP version of Apache.

Q: I'm on a Mac, and I get an error in SID that says "attempt to write a read only database." How can I fix this?

A: This usually means that the database folder does not have sufficient permissions for writing by the web user. This can happen if you create the SQL folder new, rather than copying it from the Exercise Files. Here's how to fix this: 

  1. Open a Finder window and Navigate to /Applications/XAMPP/htdocs/SQL
  2. Control-click on the SQL folder and select "Get Info" from the context menu. 
  3. Under "Sharing and Permissions" (you may need to open the disclosure triangle), in the "everyone" row, select "Read & Write."Then you can close the Info window. 
  4. Now repeat the process for the three *.db files inside the folder. 


Skills covered in this course
Business Developer Web Databases SQL

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start My Free Month

Start your free month on LinkedIn Learning, which now features 100% of courses. Develop in-demand skills with access to thousands of expert-led courses on business, tech and creative topics.

Start My Free Month

You are now leaving and will be automatically redirected to LinkedIn Learning to access your learning content.