1

I have MySQL installed. When I had the previous version, it used to start after boot automatically. This is not the case after I updated to Yosemite. In System Preferences there is an icon for MySQL and "Automatically Start MySQL Server on Startup" is checked. I tried unchecking - restart - check - restart still the same..

Everytime I boot the computer I will need to start it manually. Any fix?

  • Have you checked the system logs to see if there's anything there indicating why mysql is failing to load? – douggro Oct 28 '14 at 14:25
  • You should probably file a bug against this issue with MySQL. The fact that they are still attempting to use Startup Items, six major releases of OS X after launchd was introduced, is troubling to say the least. – tubedogg Dec 31 '14 at 6:02
2

MySQL by default tries to use StartupItems. That won't work with Yosemite.

I made a launchd control that is still compatible with the MySQL preferencepane.

Details here - https://github.com/MacMiniVault/Mac-Scripts/blob/master/mmvMySQL/mmvmysql-Yosemite.md

1

From stackoverflow...

I've done this and it works. Pasted instructions below...

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

<!--?xml version="1.0" encoding="UTF-8"?-->
<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>

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

The reason you need this is because the StartupItems have been removed from Yosemite. There is a note at the start of the page in Apple's docs explaining this: Startup items are a deprecated technology. Launching of daemons through this process may be removed or eliminated in a future release of OS X.

0

The best way I've found is to install MySQL with Homebrew, not from the .dmg available from the MySQL or Oracle. If you have Homebrew installed, simply run the following command in Terminal.

brew install mysql

Then to have MySQL start automatically, run the following:

brew services start mysql

You must log in to answer this question.

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