Saturday, January 8, 2011

fixing OS X MySQL

Sometimes OS X MySQL has some launchd problems. You can run the server but you get all sorts of odd messages when you try to access it via server manager. And you just can't get it to quit properly.

Here's a fix:

go to terminal and run:
sudo launchctl unload -w /System/Library/LaunchDaemons/org.mysql.mysqld.plist

go back to Server Admin and restart mysql

reboot.

Mysqld should be running fine.

3 comments:

  1. Do not like prissy java type paths, to a launch daemon yet, whats up with that?

    Like nice *nix /etc/rc.d initialization. Anything in rc.d that is executable will be run. Turning that on and off is really trivial.

    /etc/rc.d/rc.mysqld start, restart and stop. Simple and hard to break.

    I was gonna say just build your own database and stuff it with whatever you want. Learning the query stuff is sorta the fun part.

    ReplyDelete
  2. The point, actually, is to pull together my wife's business information which is strewn across several incompatible IT systems. Once the basics are done and I've got a data store that Pentaho is comfortable with, I'm going to be building ETL scripts to pull in and push out all that information so the amount of useless, duplicate typing she has to do is reduced.

    Build your own? I'm not that much of a masochist.

    ReplyDelete
  3. This comment system is broke. If I leave the page for any reason it's all gone. These days that is broke.

    ReplyDelete