the joys of Web development
Jul. 20th, 2011 10:58 amI spent much of yesterday and the day before fighting with my computer. See, when I upgraded to OS 10.6, it apparently wiped out all the settings I had in place to let PHP and MySQL work. Okay, not a big deal, I just have to set things up again, right? Well, PHP wasn't a problem, it was just a matter of finding the right settings document and changing a few lines. SQL on the other hand...
First, Apple is no help. When they came out with OS 10 they made a big deal about it being developer friendly, you can get right into the code, etc. etc. Not untrue, but THEY don't tell you how to set any of it up. I don't even want to mess around with the computer's code, all I want to do is build Web pages using MySQL. The OS has the database capabilities, but it's switched off by default and they don't give you ANY help with switching it on.
Anyway, Googling turns up a number of pages with instructions and walk-throughs, and they all seem simple enough. Except that they all have something like this:
First off, there's at least two dozen items in the package, not three. But okay, I'll find those three and install them first. But no matter which piece I try to install, I get an error. I found another set of instructions that has you use Terminal (Unix commands), and those work up to the point where - you guessed it - I try to install the SQL package. Then I get a "unknown command" error. The SQL package has a text file with instructions to install using Terminal, but those also give me an "unknown command" error.
Clearly I'm missing something.
lynda.com has a video tutorial on setting up MySQL on a Mac, and they're usually pretty good. At least with a video, I should be able to see what it's supposed to look like and where things are supposed to go. Hopefully. I don't want to spend too much more time on this but I want things to work.
Goddamit Apple, this shouldn't be this hard.
Edit: Should've gone to lynda.com in the first place. It's working now, but it seems to have wiped out all the test databases I'd had. Great.
First, Apple is no help. When they came out with OS 10 they made a big deal about it being developer friendly, you can get right into the code, etc. etc. Not untrue, but THEY don't tell you how to set any of it up. I don't even want to mess around with the computer's code, all I want to do is build Web pages using MySQL. The OS has the database capabilities, but it's switched off by default and they don't give you ANY help with switching it on.
Anyway, Googling turns up a number of pages with instructions and walk-throughs, and they all seem simple enough. Except that they all have something like this:
- Download the MySQL package for Mac OS X.5 (32 or 64 bits depending on your machine)
- Install everything in the package in this order: mysql, the startup item, the preference pane.
- Start MySQL in the preference pane.
First off, there's at least two dozen items in the package, not three. But okay, I'll find those three and install them first. But no matter which piece I try to install, I get an error. I found another set of instructions that has you use Terminal (Unix commands), and those work up to the point where - you guessed it - I try to install the SQL package. Then I get a "unknown command" error. The SQL package has a text file with instructions to install using Terminal, but those also give me an "unknown command" error.
Clearly I'm missing something.
lynda.com has a video tutorial on setting up MySQL on a Mac, and they're usually pretty good. At least with a video, I should be able to see what it's supposed to look like and where things are supposed to go. Hopefully. I don't want to spend too much more time on this but I want things to work.
Goddamit Apple, this shouldn't be this hard.
Edit: Should've gone to lynda.com in the first place. It's working now, but it seems to have wiped out all the test databases I'd had. Great.