Look in /usr/local/mysql/data for a file called "{hostname}.err" where "hostname" will be the hostname of your Mac. For example, if your Mac is named "bob" the error log will be "bob.err". Look at the bottom of that file to see what problem MySQL encountered that caused it to stop.
Peace...