修复 OS X 10.10 Yosemite 下 MySQL 无法自动启动的问题
在升级到 OS X Yosemite 后,如果 MySQL 无法自动启动了,可以手工启动
sudo -s
/usr/local/mysql/bin/mysqld_safe --user=mysql &
看看启动是否正常,然后就可以使用如下的方式让 MySQL 自动启动:
- 创建一个新文件:/Library/LaunchDaemons/com.mysql.plist
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>KeepAlive</key>
<true />
<key>Label</key>
<string>com.mysql.mysqld</string>
<key>ProgramArguments</key>
<array>
<string>/usr/local/mysql/bin/mysqld_safe</string>
<string>--user=mysql</string>
</array>
</dict>
</plist>
- 更新权限并添加到 launchctl
sudo chown root:wheel /Library/LaunchDaemons/com.mysql.plist
sudo chmod 644 /Library/LaunchDaemons/com.mysql.plist
sudo launchctl load -w /Library/LaunchDaemons/com.mysql.plist
这是由于 Yosemite 废弃了 StartupItems 导致的