Go Back   MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Thread Tools Search this Thread Display Modes
Old Jun 29, 2009, 02:39 AM   #1
macrumors 6502a
Join Date: Feb 2008
Making a script to start and stop mySQL.

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?

Last edited by NRose8989; Jun 29, 2009 at 03:07 AM.
NRose8989 is offline   0 Reply With Quote
Old Jun 29, 2009, 03:43 AM   #2
macrumors 6502
Join Date: Feb 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.
BertyBoy is offline   0 Reply With Quote
Old Jun 29, 2009, 03:13 PM   #3
Thread Starter
macrumors 6502a
Join Date: Feb 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.
NRose8989 is offline   0 Reply With Quote

MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Start/stop a shell script loop hakonandersson Mac Programming 2 May 29, 2013 05:58 AM
How to Make Firefox Stop Lagging and Give Script Errors iPowers Mac Applications and Mac App Store 2 Jan 21, 2013 07:30 PM
How can I stop all my files making backups of themselves? fredthe3rd Mac OS X 10.7 Lion 1 Oct 30, 2012 05:22 PM
My script is making it impossible to quit an app it works with Mephistopelus Mac Programming 9 Oct 17, 2012 08:39 AM

Forum Jump

All times are GMT -5. The time now is 08:51 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2015, MacRumors.com, LLC