5

In the System Preferences panel, I have the MySQL there.

enter image description here

enter image description here

I chose it to start up every time my Mac starts up, however this doesn't work, I have restarted MySQL many times, but it will not start up at all - which I require to start up manually.

How can I fix this?

  • Did you search for any hints in /var/log already? – nohillside Nov 6 '11 at 14:44
2
+50

Starting MySQL server automatically actually means executing the /usr/local/mysql/bin/mysqld dæmon on startup. If MySQL won't do it for you, it's easy enough to add the necessary instructions yourself.

For this, we'll add a launchd job descriptor to the /Library/LaunchDaemons folder. The procedure is very well described in this Mac OS X Hints article.


Note: I would have liked to copy and edit it here, since it adds some details that are unnecessary in this case, but I couldn't find license information about Mac OS X Hints' content, so I'll simply link.

1

There should also be logs in /usr/local/mysql/data. You'll have to "sudo su" from a Terminal session in order to see that directory. Check for any errors being reported in a filed named like this: "Your-computer-name.local.err"

Report back whatever you see that doesn't make sense.

You can also check out the startup script to make sure there are no errors. Find that here: /Library/StartupItems/MySQLCOM/MYSQLCOM

  • Hmm, I don't see any type of logs in the /usr/local/mysql/data directory. The file/directory does not exist in /Library/StartupItems/MySQLCOM/MYSQLCOM. – MacMac Nov 6 '11 at 19:54
1

Use terminal and paste this snippet:

sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysqld.plist
  • You don't have to be root to use sudo, being an admin user is enough. – nohillside Nov 18 '11 at 13:56

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .