Making a script to start and stop mySQL.

Discussion in 'Mac Programming' started by NRose8989, Jun 29, 2009.

  1. NRose8989 macrumors 6502a

    Feb 6, 2008
    I manually installed mySQL 5.1 so I can't use the pref pane that I would normally get when installing mySQL as a installer package. So I would like to make two scripts (".start" and ".stop") that will live in my home folder, so I can quickly start and stop them when open terminal. I kinda have an idea on how to make it but I don't know how to have the script enter my admin password when it is prompted (or if thats even possible).

    the two commands to start and stop it are as follows:

    to start:
    sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysqld.plist
    to stop:
    sudo launchctl unload -w /Library/LaunchDaemons/com.mysql.mysqld.plist
    Thanks in advance.

    EDIT: Nevermind I think I figured it out, Just had to change some permissions.

    EDIT #2: So they work just fine but now I have that natural feeling to make it better. I currently have two scripts, one for starting, and one for stopping. How would I go about rolling them into one single script called ".mysql" and it will test if the mySQL server is already running (or not running) then execute the needed command. Do any of you know what is returned if one of these commands failed to execute?

    I would think that I could use
    and a series of if statements, assuming if the commands returned a integer.

    any ideas?
  2. BertyBoy macrumors 6502

    Feb 1, 2009
    Why can't you use the pref pane to start / stop MySQL ?

    All it does will be to call mysqld_safe ? wherever that happens to be in your PATH.
  3. NRose8989 thread starter macrumors 6502a

    Feb 6, 2008
    Ya the pref panes doesn't work because I followed this tutorial and it doesn't work, not sure why but it doesn't.

    I did it this way because the mySQL install packages didn't work when using ruby on rails.

Share This Page