Skip navigation

Formatting SQL

Formatting SQL: SQL Essential Training
Formatting SQL: SQL Essential Training

Join for an in-depth discussion in this video Formatting SQL, part of SQL Essential Training.

Resume Transcript Auto-Scroll
Skill Level Beginner
3h 27m
Duration
3,431,855
Views
Show More Show Less

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
Developer IT 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 Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now