MySQL launchd item for Mac OS X Tiger

(Originally posted at Unquiet)

I had to reinstall Mysql because it wasn’t one of the things I backed up before erasing my hard drive. Since I’m now running Mac OS X 10.4 “Tiger”, I decided to set it up to start when the system boots, but the system for creating startup items has changed slightly. So I saved the following xml in /Library/LaunchDaemons/com.mysql.Mysql.plist:

    
    
    
        Label
        com.mysql.Mysql
        OnDemand
        
        ProgramArguments
        
                /usr/local/mysql/bin/mysqld_safe
        
        ServiceDescription
        Mysql 4.1 Database Server
        UserName
        mysql
        WorkingDirectory
        /usr/local/mysql
    
    

Note that I'm using the official OSX distribution of MySQL... but with a few changes to match your database location, you can get this to work with other installs (fink, darwinports, etc).