yosemite mysql 启动,如何在OS X Yosemite / El Capitan上启动时自动加载MySQL

After upgrading OS X my install of MySQL stopped loading on startup.

"The Startup Item installation adds a variable MYSQLCOM=-YES- to the

system configuration file /etc/hostconfig. If you want to disable the

automatic startup of MySQL, change this variable to MYSQLCOM=-NO-."

So, I opened that file and it says:

# This file is going away

AFPSERVER=-NO-

AUTHSERVER=-NO-

TIMESYNC=-NO-

QTSSERVER=-NO-

MYSQLCOM=-YES-

I assume OSX dev's added the # This file is going away but I'm not certain.

If that is the case, what is the proper way to start MySQL on startup on OSX Yosemite?

解决方案

This is what fixed it:

First, create a new file: /Library/LaunchDaemons/com.mysql.mysql.plist

KeepAlive

Label

com.mysql.mysqld

ProgramArguments

/usr/local/mysql/bin/mysqld_safe

--user=mysql

Then update permissions and add it to launchctl:

sudo chown root:wheel /Library/LaunchDaemons/com.mysql.mysql.plist

sudo chmod 644 /Library/LaunchDaemons/com.mysql.mysql.plist

sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysql.plist